strange query behavior - Mailing list pgsql-performance

From Tim Jones
Subject strange query behavior
Date
Msg-id 47668A1334CDBF46927C1A0DFEB223D39F79A5@mail.optiosoftware.com
Whole thread Raw
Responses Re: strange query behavior
Re: strange query behavior
List pgsql-performance
Hi,

  I have a query that uses an IN clause and it seems in perform great
when there is more than two values in it but if there is only one it is
really slow. Also if I change the query to use an = instead of IN in the
case of only one value it is still slow. Possibly I need to reindex this
particular index?

thanks

Tim Jones
Healthcare Project Manager
Optio Software, Inc.
(770) 576-3555


pgsql-performance by date:

Previous
From: "Bucky Jordan"
Date:
Subject: Re: New to PostgreSQL, performance considerations
Next
From: Ragnar
Date:
Subject: Re: strange query behavior