Re: Have I b0rked something? Slow comparisons on "where x in (...)"

From: Stephen Harris <lists(at)spuddy(dot)org>
To: Dann Corbit <DCorbit(at)connx(dot)com>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Have I b0rked something? Slow comparisons on "where x in (...)"
Date: 2007-05-02 19:51:17
Message-ID: 20070502195117.GA22941@pugwash.spuddy.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, May 02, 2007 at 12:45:08PM -0700, Dann Corbit wrote:
> Have you done a vacuum on the table recently?

We vacuum daily and cluster weekly after the nightly activities have been
performed.

> IN list, then the IN list might benefit from a bit of analysis for

The IN list is just a set of integers (it's an integer index) generated
from some selects on other tables earlier in our processing. I don't
have any choice as to what is in the IN list :-)

--

rgds
Stephen

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dan Weber 2007-05-02 20:18:32 forcing use of a specific (expression) index?
Previous Message Dann Corbit 2007-05-02 19:45:08 Re: Have I b0rked something? Slow comparisons on "where x in (...)"