> On Thu, Jun 24, 2010 at 17:14, Alban Hertroys > <dalroi@xxxxxxxxxxxxxxxxxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
