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

Re: query optimization

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

In response to

Responses

pgsql-performance by date

Next:From: Faheem MithaDate: 2009-11-23 23:49:18
Subject: Re: query optimization
Previous:From: Faheem MithaDate: 2009-11-23 22:47:15
Subject: query optimization

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