Can you provide these details work_mem How much physical memory there is on your system Most out of memory errors are associated with a high work_mem setting On Sun, Jun 13, 2010 at 6:25 AM, AI Rumman <rummandba@xxxxxxxxx> wrote: > Whenever I run this query, I get out of memory error: > > > explain analyze > select > email_track.count AS "Emails_Access_Count", > activity.subject AS "Emails_Subject", > crmentity.crmid AS EntityId_crmentitycrmid > from > (select * from crmentity where deleted = 0 and createdtime between (now() - > interval '6 month') and now() ) as crmentity > inner join > (select * from activity where activitytype = 'Emails' and date_start > between (now() - interval '6 month') and now()) as activity > on crmentity.crmid=activity.activityid > inner join emaildetails on emaildetails.emailid = crmentity.crmid > inner join vantage_email_track on > vantage_email_track.mailid=emaildetails.emailid > left join seactivityrel on seactivityrel.activityid = emaildetails.emailid > > -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
