|
From: Juned K. <jkh...@gm...> - 2014-04-17 11:13:29
|
so i have to do experiment for this. i really need that much connection. Thanks for the suggestion @Michael On Thu, Apr 17, 2014 at 11:40 AM, Michael Paquier <mic...@gm... > wrote: > 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 > -- Thanks, Juned Khan iNextrix Technologies Pvt Ltd. www.inextrix.com |