Re: query problem

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: query problem
Дата
Msg-id 14684.1097679793@sss.pgh.pa.us
обсуждение исходный текст
Ответ на query problem  (Robin Ericsson <robin.ericsson@profecta.se>)
Ответы Re: query problem  (Robin Ericsson <robin.ericsson@profecta.se>)
Список pgsql-performance
Robin Ericsson <robin.ericsson@profecta.se> writes:
> I sent this to general earlier but I was redirected to performance.

Actually, I think I suggested that you consult the pgsql-performance
archives, where this type of problem has been hashed out before.
See for instance this thread:
http://archives.postgresql.org/pgsql-performance/2004-07/msg00169.php
particularly
http://archives.postgresql.org/pgsql-performance/2004-07/msg00175.php
http://archives.postgresql.org/pgsql-performance/2004-07/msg00184.php
http://archives.postgresql.org/pgsql-performance/2004-07/msg00185.php
which show three different ways of getting the planner to do something
sane with an index range bound like "now() - interval".

            regards, tom lane

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

Предыдущее
От: ken
Дата:
Сообщение: Re: query problem
Следующее
От: Robin Ericsson
Дата:
Сообщение: Re: query problem