Re: analyzing intermediate query

From: PFC <lists(at)peufeu(dot)com>
To: Andrus <kobruleht2(at)hot(dot)ee>, pgsql-performance(at)postgresql(dot)org
Subject: Re: analyzing intermediate query
Date: 2008-12-02 14:13:50
Message-ID: op.uljghcfxcigqcu@soyouz
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 response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Andrus 2008-12-02 14:37:37 Re: analyzing intermediate query
Previous Message Andrus 2008-12-02 14:00:48 Re: analyzing intermediate query