From: | Thom Brown <thombrown(at)gmail(dot)com> |
---|---|
To: | Faheem Mitha <faheem(at)email(dot)unc(dot)edu> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: query optimization |
Date: | 2009-11-23 23:25:24 |
Message-ID: | bddc86150911231525r7e91a2c8rcfff84df1793162@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Faheem Mitha | 2009-11-23 23:49:18 | Re: query optimization |
Previous Message | Faheem Mitha | 2009-11-23 22:47:15 | query optimization |