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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
