Skip site navigation (1) Skip section navigation (2)

query optimization

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 (view raw or flat)
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.

Responses

pgsql-performance by date

Next:From: Thom BrownDate: 2009-11-23 23:25:24
Subject: Re: query optimization
Previous:From: Scott MarloweDate: 2009-11-23 21:55:07
Subject: Re: Best possible way to insert and get returned ids

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group