Running out of memory while making a join
Running out of memory while making a join
От:
rahul143 <rk204885@gmail.com>
Дата:
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.