4 ms·
I've done a lot of work with pgpool over the past year, be aware there are lots of situations where it won't work for you. For example if your devs don't write
by mrmondo 12y ago
I've done a lot of work with pgpool over the past year, be aware there are lots of situations where it won't work for you. For example if your devs don't write their own SQL and instead use a framework with limited control you're going to have a bad time.
- jbardnz 12y agoI use Postgres with Laravel so i'm not writing any SQL queries directly, can you go into more detail about why this won't work for me?
- mrmondo 12y agoI was speaking to the author (Tatsuo Ishii) around the reliability of PGPool-II when you did not have complete control over your SQL, he made it clear that if you cannot control what kinds of SQL is and isn't run from the application you and I quote "I will suggest you avoid pgpool-II.", He also noted that "Pgpool-II does not handle multi statements query very well" so pretty much count yourself out of using PGPool if you're using any multi-statement queries which is at least in our case a great deal of our SQL.