Re: [ADMIN] Copying large tables with DBLink

2005-03-24 Thread Michael Fuhr
On Thu, Mar 24, 2005 at 01:59:44PM -0500, Chris Hoover wrote: > > Has anyone had problems with memory exhaustion and dblink? We were > trying to use dblink to convert our databases to our new layout, and had > our test server lock up several times when trying to copy a table that > was signific

Re: [ADMIN] Copying large tables with DBLink

2005-03-24 Thread Tom Lane
"Chris Hoover" <[EMAIL PROTECTED]> writes: > Has anyone had problems with memory exhaustion and dblink? We were > trying to use dblink to convert our databases to our new layout, and had > our test server lock up several times when trying to copy a table that > was significantly larger than our

Re: [ADMIN] Copying large tables with DBLink

2005-03-24 Thread Joe Conway
Chris Hoover wrote: Has anyone had problems with memory exhaustion and dblink? We were trying to use dblink to convert our databases to our new layout, and had our test server lock up several times when trying to copy a table that was significantly larger than our memory and swap. Basically whe

[ADMIN] Copying large tables with DBLink

2005-03-24 Thread Chris Hoover
Has anyone had problems with memory exhaustion and dblink? We were trying to use dblink to convert our databases to our new layout, and had our test server lock up several times when trying to copy a table that was significantly larger than our memory and swap. Basically where were doing an i