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