Postgres Pro
Downloads
Home   >   mailing lists

Re: analyzing intermediate query - Mailing list pgsql-performance

From PFC
Subject Re: analyzing intermediate query
Date
Msg-id op.uljghcfxcigqcu@soyouz
Whole thread Raw
In response to Re: analyzing intermediate query  ("Andrus" <kobruleht2@hot.ee>)
Responses Re: analyzing intermediate query
List pgsql-performance
Tree view 
> 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...

pgsql-performance by date:

Previous
From: "Andrus"
Date:
Subject: Re: analyzing intermediate query
Next
From: "Andrus"
Date:
Subject: Re: analyzing intermediate query