From: | tv(at)fuzzy(dot)cz |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Bad query performance with more conditions? |
Date: | 2010-06-24 10:40:36 |
Message-ID: | 2955.85.160.46.197.1277376036.squirrel@sq.gransy.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> On Thu, Jun 24, 2010 at 17:14, Alban Hertroys
> <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl> wrote:
>>
>> You didn't provide explain analyse results for those queries, so I'm
>> just guessing here, but I think you should add indices to email_msg_id
>> and email_sender_text to speed up those queries.
>>
>> Alban Hertroys
>>
>
> Thanks for your suggestion.
> The explain analyzes provided in another mail.
No, you haven't. Alban asked for 'EXPLAIN ANALYZE' output but you've
provided just 'EXPLAIN' output - that's a big difference, as we can't see
if the statistics are off or what is going on.
Alban actually provided some useful insights in one of the following
e-mails, but EXPLAIN ANALYZE output would be useful to confirm his
conclusions.
Tomas
From | Date | Subject | |
---|---|---|---|
Next Message | Karsten Hilbert | 2010-06-24 12:19:37 | Re: copy/duplicate database schemas |
Previous Message | Alban Hertroys | 2010-06-24 09:30:00 | Re: Bad query performance with more conditions? |