|
From: Michael P. <mic...@gm...> - 2014-04-17 06:10:27
|
On Thu, Apr 17, 2014 at 2:51 PM, Juned Khan <jkh...@gm...> wrote: > And i can use pgpool and pgbouncer with pgxc right ? In front of the Coordinators, that's fine. But I am not sure in from of the Datanodes as XC has one extra connection parameter to identify the node type from which connection is from, and a couple of additional message types to pass down transaction ID, timestamp and snapshot data from Coordinator to Datanodes (actually Coordinators as well for DDL queries). If those message types and/or connection parameters get filtered by pgpool or pgbouncer, well you cannot use them. I've personally never given a try though, but the idea is worth an attempt to reduce lock contention that could be caused by a too high value of max_connections. -- Michael |