2009/11/23 Faheem Mitha <faheem@xxxxxxxxxxxxx>
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
