query optimization - Mailing list pgsql-performance

From Faheem Mitha
Subject query optimization
Date
Msg-id alpine.DEB.2.00.0911231721250.25872@orwell.homelinux.org
Whole thread Raw
Responses Re: query optimization  (Thom Brown <thombrown@gmail.com>)
Re: query optimization  (Robert Haas <robertmhaas@gmail.com>)
List 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.

pgsql-performance by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Best possible way to insert and get returned ids
Next
From: Thom Brown
Date:
Subject: Re: query optimization