Re: Is it require further tuning

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: Is it require further tuning
Дата
Msg-id AANLkTinr1RZzy0S0t3aY7wfa9sjYxj6rh5Z2xxPKqPj5@mail.gmail.com
обсуждение исходный текст
Ответ на Is it require further tuning  (Adarsh Sharma <adarsh.sharma@orkash.com>)
Список pgsql-performance
On Wed, Mar 2, 2011 at 11:31 PM, Adarsh Sharma <adarsh.sharma@orkash.com> wrote:
> Don't know why it uses Seq Scan on loc_context_terror as i have indexes on
> the desired columns as well.

I don't see how an index scan would help.  The query appears to need
all the rows from that table.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

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

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: Slowing UPDATEs inside a transaction
Следующее
От: Landreville
Дата:
Сообщение: Calculating 95th percentiles