Re: query optimization

2009/11/23 Faheem Mitha <faheem(at)email(dot)unc(dot)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