Re: Copying large tables with DBLink

"Chris Hoover" <revoohc(at)sermonaudio(dot)com> 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 memory and swap.

You're not going to be able to do that with dblink, nor any other
set-returning function, because the current implementation of SRFs
always materializes the entire function result in temporary memory/swap.

Consider something like
pg_dump -t srctab srcdb | psql destdb
instead.

regards, tom lane