Re: An "obvious" index not being used

Поиск
Список
Период
Сортировка
От Francisco Reyes
Тема Re: An "obvious" index not being used
Дата
Msg-id cone.1216431907.692690.79328.1000@zoraida.natserv.net
обсуждение исходный текст
Ответ на An "obvious" index not being used  (Daniele Varrazzo <piro@develer.com>)
Ответы Re: An "obvious" index not being used  (Daniele Varrazzo <piro@develer.com>)
Список pgsql-performance
Daniele Varrazzo writes:

> I suspect the foo.account_id statistical data are not used at all in query:
> the query planner can only estimate the number of accounts to look for, not

You mentioned you bumped your default_statistics_target.
What did you increase it to?
My data sets are so "strange" that anything less than 350 gives many bad
plans.

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

Предыдущее
От: Francisco Reyes
Дата:
Сообщение: Re: 3ware vs Areca
Следующее
От: Stephane Bailliez
Дата:
Сообщение: Performance on Sun Fire X4150 x64 (dd, bonnie++, pgbench)