From: | Anj Adu <fotographs(at)gmail(dot)com> |
---|---|
To: | AI Rumman <rummandba(at)gmail(dot)com> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: out of memory |
Date: | 2010-06-13 13:59:58 |
Message-ID: | AANLkTik_91KKF0n5_BGbB5E9ngnxcDvpLMKImW0sbKSy@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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(at)gmail(dot)com> 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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2010-06-13 14:00:16 | Re: Re: [PERFORM] Large (almost 50%!) performance drop after upgrading to 8.4.4? |
Previous Message | AI Rumman | 2010-06-13 13:25:32 | out of memory |