On Thu, Jun 24, 2010 at 17:14, Alban Hertroys <dal...@solfertje.student.utwente.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. > > Actually, from your results it would appear that you did create an index on > the former, while you probably didn't on the latter, causing the second query > to have to scan sequentially through all records. > > Alban Hertroys >
Thanks for your suggestion. The explain analyzes provided in another mail. While I did add indices for both email_msg_id and email_sender_text. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
