The following bug has been logged online:
Bug reference: 1386
Logged by: Gustav Lindenberg
Email address: glindenberg@webmail.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