Skip site navigation (1) Skip section navigation (2)

BUG #1389: 2 x 3.1 Gz Intel Cpu, 4Gb RAM, 2Gb Swap, Linux, Kernel 2.4.21-20.ELsmp #1 SMP

From: "Gustav Lindenberg" <glindenberg(at)webmail(dot)co(dot)za>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1389: 2 x 3.1 Gz Intel Cpu, 4Gb RAM, 2Gb Swap, Linux, Kernel 2.4.21-20.ELsmp #1 SMP
Date: 2005-01-12 09:22:15
Message-ID: 200501120922.j0C9MF10023388@developer.pgadmin.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      1389
Logged by:          Gustav Lindenberg
Email address:      glindenberg(at)webmail(dot)co(dot)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

pgsql-bugs by date

Next:From: Christoph BeckerDate: 2005-01-12 10:13:29
Subject: rc4 and rc3, some deleted, but still needed text in the documentation, please put it back again
Previous:From: Holger KlawittDate: 2005-01-12 08:31:09
Subject: BUG #1388: documentation/announcement suggestion

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group