On Sat, Feb 21, 2009 at 1:23 AM, Michael Monnerie
<michael.monnerie@is.it-management.at> wrote:
> Also a question: Because I must read all data, the psql client runs out
> of memory, trying to cache all the 10GB from that table. I circumvented
> this with selecting only parts of the table all the time. Is there a
> smart way to do such a select without caching the results in memory? Is
> that what temporary tables and "select into" are made for? I just want
> to know the recommended way for doing huge queries.
You can dump individual tables with pg_dump -t table1 -t table2. That
should work without running out of memory. And yeah, temp tables and
select into are a good way to get your data ready to be pg_dumped.