Postgres Pro
Downloads
Home   >   mailing lists

Re: query optimization - Mailing list pgsql-performance

From Thom Brown
Subject Re: query optimization
Date
Msg-id bddc86150911231525r7e91a2c8rcfff84df1793162@mail.gmail.com
Whole thread Raw
In response to query optimization  (Faheem Mitha <faheem@email.unc.edu>)
Responses Re: query optimization  (Faheem Mitha <faheem@email.unc.edu>)
List pgsql-performance
Tree view
2009/11/23 Faheem Mitha <faheem@email.unc.edu>

Hi everybody,

I've got two queries that needs optimizing. Actually, there are others, but these are pretty representative.

You can see the queries and the corresponding plans at

http://bulldog.duhs.duke.edu/~faheem/snpdb/opt.pdf

or

http://bulldog.duhs.duke.edu/~faheem/snpdb/opt.tex

if you prefer text (latex file, effectively text in this case)

The background to this is at http://bulldog.duhs.duke.edu/~faheem/snpdb/diag.pdf

If more details are required, let me know and I can add them. I'd appreciate suggestions about how to make these queries go faster.

Please CC this email address on any replies.

                                  Regards, Faheem.



Hi Faheem,

There appears to be a discrepancy between the 2 PDFs you provided.  One says you're using PostgreSQL 8.3, and the other shows you using common table expressions, which are only available in 8.4+.

Thom

pgsql-performance by date:

Previous
From: Faheem Mitha
Date:
Subject: query optimization
Next
From: Faheem Mitha
Date:
Subject: Re: query optimization