From: Andrus <kobruleht2@hot.ee>
To: pgsql-performance@postgresql.org
To: PFC <lists@peufeu.com>
Subject: Re: analyzing intermediate query
Date: Tue, 2 Dec 2008 16:37:37 +0200
Message-ID: <95776070DDC841978DF8335DCF59D6BB@andrusnotebook> (raw)
In-Reply-To: <op.uljghcfxcigqcu@soyouz>
References: <gh38cg$1544$1@news.hub.org>
<op.uljfbad8cigqcu@soyouz>
<B52A6C218D2145378337CFDC89699D99@andrusnotebook>
<op.uljghcfxcigqcu@soyouz>
>> My list can contain 1 .. 100000 records and table contains 3000000
>> records and is growing.
>
> Ah. No IN(), then ;)
> Temp table + ANALYZE seems your only option...
In 8.3 or 8.4 I think that IN() or temp table produce exactly the same
result.
Andrus.
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-performance@postgresql.org
Cc: kobruleht2@hot.ee, lists@peufeu.com
Subject: Re: analyzing intermediate query
In-Reply-To: <95776070DDC841978DF8335DCF59D6BB@andrusnotebook>
* 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