Running out of memory while making a join - Mailing list pgsql-general

From rahul143
Subject Running out of memory while making a join
Date
Msg-id 1354463955370-5734605.post@n5.nabble.com
Whole thread Raw
List pgsql-general
Hi,

The following SQL join command runs the PostgreSQL server out of memory. The
server runs on a box with Red Hat Enterprise Linux Server release 6.3
(Santiago) and PostgreSQL 8.3.21.

select wm_nfsp from "5611_isarq".wm_nfsp
left join "5611_nfarq".nfe on
wm_nfsp.tpdoc = 7 where 1 = 1 and
wm_nfsp.codpre = 2866 and
wm_nfsp.compet = '10/2012';




-----




--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Running-out-of-memory-while-making-a-join-tp5734605.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


pgsql-general by date:

Previous
From: Dhiraj Gupta
Date:
Subject: Database schema
Next
From: rahul143
Date:
Subject: Bug in postgres 9.2 installation: pg_archivecleanup: command not found