The following bug has been logged online:

Bug reference: 1386
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
lssprod.localdomain 2.4.21-20.ELsmp #1 SMP Wed Aug 18
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;

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 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)