| From: | Faheem Mitha <faheem(at)email(dot)unc(dot)edu> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | query optimization |
| Date: | 2009-11-23 22:47:15 |
| Message-ID: | alpine.DEB.2.00.0911231721250.25872@orwell.homelinux.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thom Brown | 2009-11-23 23:25:24 | Re: query optimization |
| Previous Message | Scott Marlowe | 2009-11-23 21:55:07 | Re: Best possible way to insert and get returned ids |