The following bug has been logged online:

Bug reference: 1389
Logged by: Gustav Lindenberg
Email address: glindenberg (AT) webmail (DOT) co.za
PostgreSQL version: 8.0.0rc2
Operating system: Red Hat Enterprise Linux ES release 3 (Taroon Update 3)
Description: 2 x 3.1 Gz Intel Cpu, 4Gb RAM, 2Gb Swap, Linux, Kernel
2.4.21-20.ELsmp #1 SMP
Details:

I get the following error when trying to copy(select) to a text file using
psql:
"out of memory for query result"

The error comes up after about 45 minutes when free swap hist 0.

This is my steps:
$ psql claim
\o claim_summary_old.unl
claim=# \a
Output format is unaligned.
claim=# select * from claim_summary where cs_ch_serial < 21778534;
out of memory for query result


Table claim_summary has +-29000000 rows. Need to unload +- 20000000 rows to
text file.
When I change the select to a delete statement it works without error.


Other system info:
$ ipcs -m
0x0052e2c1 131076 postgres 600 591732736 3

$ rpm -qa |grep -i gcc
libgcc-ssa-3.5ssa-0.20030801.48
gcc-java-ssa-3.5ssa-0.20030801.48
gcc-g77-ssa-3.5ssa-0.20030801.48
gcc-3.2.3-42
gcc-objc-ssa-3.5ssa-0.20030801.48
gcc-g77-3.2.3-42
gcc-java-3.2.3-42
gcc-c++-ssa-3.5ssa-0.20030801.48
gcc-ssa-3.5ssa-0.20030801.48
gcc-objc-3.2.3-42
libgcc-3.2.3-42
gcc-gnat-3.2.3-42

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html