Re: analyzing intermediate query - Mailing list pgsql-performance

From Andrus
Subject Re: analyzing intermediate query
Date
Msg-id 95776070DDC841978DF8335DCF59D6BB@andrusnotebook
Whole thread Raw
In response to Re: analyzing intermediate query  (PFC <lists@peufeu.com>)
Responses Re: analyzing intermediate query
List pgsql-performance
>> 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.


pgsql-performance by date:

Previous
From: PFC
Date:
Subject: Re: analyzing intermediate query
Next
From: PFC
Date:
Subject: Re: analyzing intermediate query