strange query behavior

Поиск
Список
Период
Сортировка
От Tim Jones
Тема strange query behavior
Дата
Msg-id 47668A1334CDBF46927C1A0DFEB223D39F79A5@mail.optiosoftware.com
обсуждение исходный текст
Ответы Re: strange query behavior  (Ragnar <gnari@hive.is>)
Re: strange query behavior  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: "Bucky Jordan"
Дата:
Сообщение: Re: New to PostgreSQL, performance considerations
Следующее
От: Ragnar
Дата:
Сообщение: Re: strange query behavior