From: | AI Rumman <rummandba(at)gmail(dot)com> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | out of memory |
Date: | 2010-06-13 13:25:32 |
Message-ID: | AANLkTimHKcglpoyr3u5BbQ5i9-JqlY6xL1hmYcXc3QB0@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Anj Adu | 2010-06-13 13:59:58 | Re: out of memory |
Previous Message | AI Rumman | 2010-06-13 10:45:31 | Re: query hangs |