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. > > 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
