Re: [GENERAL] dblink performance

2011-12-07 Thread Merlin Moncure
On Wed, Dec 7, 2011 at 3:37 PM, Marc Mamin wrote: >> > >> > I find dblink being a nice tool as long as the data volume to >> transfer >> > remains low. >> > I've evaluated it to implement a clustered Postgres environment, but >> > gave it up due to the poor performances. >> > Still waiting for the

Re: [GENERAL] dblink performance

2011-12-07 Thread Marc Mamin
> > > > I find dblink being a nice tool as long as the data volume to > transfer > > remains low. > > I've evaluated it to implement a clustered Postgres environment, but > > gave it up due to the poor performances. > > Still waiting for the binary transfer before the next try ;-) > > Binary trans

Re: [GENERAL] dblink performance

2011-12-07 Thread Merlin Moncure
On Wed, Dec 7, 2011 at 2:47 PM, Marc Mamin wrote: >> On Wed, Dec 7, 2011 at 10:14 AM, Alex Bible > wrote: >> > >> > Hello All, >> > >> > I'm currently on a development team utilizing PostgreSQL and we are >> looking into the possibility of using dblink to reference an external >> database (read o

Re: [GENERAL] dblink performance

2011-12-07 Thread Bruno Lavoie
Le 2011-12-07 11:14, Alex Bible a écrit : Hello All, I'm currently on a development team utilizing PostgreSQL and we are looking into the possibility of using dblink to reference an external database (read only). Our system administrator and DBA were concerned about the performance impact th

Re: [GENERAL] dblink performance

2011-12-07 Thread Marc Mamin
> On Wed, Dec 7, 2011 at 10:14 AM, Alex Bible wrote: > > > > Hello All, > > > > I'm currently on a development team utilizing PostgreSQL and we are > looking into the possibility of using dblink to reference an external > database (read only). Our system administrator and DBA were concerned > abou

Re: [GENERAL] dblink performance

2011-12-07 Thread Merlin Moncure
On Wed, Dec 7, 2011 at 10:14 AM, Alex Bible wrote: > > Hello All, > > I’m currently on a development team utilizing PostgreSQL and we are looking > into the possibility of using dblink to reference an external database (read > only). Our system administrator and DBA were concerned about the perf

[GENERAL] dblink performance

2011-12-07 Thread Alex Bible
Hello All, I'm currently on a development team utilizing PostgreSQL and we are looking into the possibility of using dblink to reference an external database (read only). Our system administrator and DBA were concerned about the performance impact that cross-database queries would have on a produc