From: Achilleas Mantzios <achill@matrix.gatewaynet.com>
To: pgsql-admin@postgresql.org
Cc: Kevin Grittner <Kevin.Grittner@wicourts.gov>
Subject: Re: Postgresql 9.0.2 explain analyze very slow (10x), compared to actual query time
Date: Fri, 14 Jan 2011 17:49:31 +0200
Message-ID: <201101141749.31711.achill@matrix.gatewaynet.com> (raw)
In-Reply-To: <4D300C2E0200002500039569@gw.wicourts.gov>
References: <201101111753.22602.achill@matrix.gatewaynet.com>
<201101141553.38236.achill@matrix.gatewaynet.com>
<4D300C2E0200002500039569@gw.wicourts.gov>
Óôéò Friday 14 January 2011 16:41:18 ãñÜøáôå:
> 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?
Its already really fast, it doesn't matter. Anyways just tried without the distinct
...NOT EXISTS (SELECT 1 from ...
and its the same speed. The other form (NOT IN) is the problem.
>
> -Kevin
>
--
Achilleas Mantzios
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: achill@matrix.gatewaynet.com, Kevin.Grittner@wicourts.gov
Subject: Re: Postgresql 9.0.2 explain analyze very slow (10x), compared to actual query time
In-Reply-To: <201101141749.31711.achill@matrix.gatewaynet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox