Skip site navigation (1) Skip section navigation (2)

strange query behavior

From: "Tim Jones" <TJones(at)optio(dot)com>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: strange query behavior
Date: 2006-12-13 18:42:20
Message-ID: 47668A1334CDBF46927C1A0DFEB223D39F79A5@mail.optiosoftware.com (view raw or flat)
Thread:
Lists: 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


Responses

pgsql-performance by date

Next:From: Tom LaneDate: 2006-12-13 18:47:16
Subject: Re: Slow update with simple query
Previous:From: RonDate: 2006-12-13 18:03:04
Subject: Re: New to PostgreSQL, performance considerations

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group