[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

Re: [GENERAL] dblink performance

2011-12-07 Thread Merlin Moncure
On Wed, Dec 7, 2011 at 10:14 AM, Alex Bible alex.bi...@ctg.com 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

Re: [GENERAL] dblink performance

2011-12-07 Thread Marc Mamin
On Wed, Dec 7, 2011 at 10:14 AM, Alex Bible alex.bi...@ctg.com 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

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

Re: [GENERAL] dblink performance

2011-12-07 Thread Merlin Moncure
On Wed, Dec 7, 2011 at 2:47 PM, Marc Mamin m.ma...@intershop.de wrote: On Wed, Dec 7, 2011 at 10:14 AM, Alex Bible alex.bi...@ctg.com 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

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 transfer is not a

Re: [GENERAL] dblink performance

2011-12-07 Thread Merlin Moncure
On Wed, Dec 7, 2011 at 3:37 PM, Marc Mamin m.ma...@intershop.de 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