Re: analyzing intermediate query

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: <pgsql-performance(at)postgresql(dot)org>, "PFC" <lists(at)peufeu(dot)com>
Subject: Re: analyzing intermediate query
Date: 2008-12-02 14:37:37
Message-ID: 95776070DDC841978DF8335DCF59D6BB@andrusnotebook
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message PFC 2008-12-02 15:14:58 Re: analyzing intermediate query
Previous Message PFC 2008-12-02 14:13:50 Re: analyzing intermediate query