On Sat, Feb 21, 2009 at 1:23 AM, Michael Monnerie <michael.monne...@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. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
