Thread: Running out of memory while making a join

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.