2009/11/23 Faheem Mitha <fah...@email.unc.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
