Performance w/ multiple WHERE clauses

Поиск
Список
Период
Сортировка
От Aaron Held
Тема Performance w/ multiple WHERE clauses
Дата
Msg-id 007401c25f58$da559dc0$6220010a@metrony.com
обсуждение исходный текст
Ответ на Creating a field that uses totals other fields?  (Sloan Bowman <smileyq@nashlinux.com>)
Ответы Re: Performance w/ multiple WHERE clauses
Список pgsql-sql
I am running into a serious performance issue with some basic queries.

If I run something like
  select * from "Calls" WHERE               ( ("CallType" = 'LONG DIST' ))

The search takes about 15 seconds

if I run   select * from "Calls" WHERE       ( ( "DateOfCall"='06/19/02') )       AND ( ( "CallType" = 'LONG DIST' ))
[DateOfCallis a DateTime field]
 

it takes 15 minutes!

both columns are indexed individually and expalain reports and Index scan for both
queries.

Any pointers where to look next?

Running pg 7.2 on RH

Thanks,
-Aaron Held



В списке pgsql-sql по дате отправления:

Предыдущее
От: Jeff Boes
Дата:
Сообщение: Query to evaluate space used
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: Performance w/ multiple WHERE clauses