Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgresql 9.0.2 explain analyze very slow (10x), compared to actual query time - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: Postgresql 9.0.2 explain analyze very slow (10x), compared to actual query time
Date
Msg-id 4D300C2E0200002500039569@gw.wicourts.gov
Whole thread Raw
In response to Re: Postgresql 9.0.2 explain analyze very slow (10x), compared to actual query time  (Achilleas Mantzios <achill@matrix.gatewaynet.com>)
Responses Re: Postgresql 9.0.2 explain analyze very slow (10x), compared to actual query time
Re: Postgresql 9.0.2 explain analyze very slow (10x), compared to actual query time
Re: Postgresql 9.0.2 explain analyze very slow (10x), compared to actual query time
List pgsql-admin
Tree view 
Achilleas Mantzios <achill@matrix.gatewaynet.com> wrote:

> and NOT EXISTS
>    (SELECT distinct mold.id from marinerstates

Does that do better if you leave out the DISTINCT keyword?  Maybe
use * instead of the column name?

-Kevin

pgsql-admin by date:

Previous
From: Vladimir Rusinov
Date:
Subject: Re: rpm failure
Next
From: Achilleas Mantzios
Date:
Subject: Re: Postgresql 9.0.2 explain analyze very slow (10x), compared to actual query time