Re: Plan selection based on worst case scenario

Поиск
Список
Период
Сортировка
От Chema
Тема Re: Plan selection based on worst case scenario
Дата
Msg-id CALdEsqNDDMgBgOF8HYwuCG6DL0ALf8BZObn9_Qf+mSVAH-KdwA@mail.gmail.com
обсуждение исходный текст
Ответ на Plan selection based on worst case scenario  ("Darwin O'Connor" <doconno@gmail.com>)
Список pgsql-performance
Дерево обсуждения

Hey Darwin,

you don't mention your version or config, but it's always good to go through https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server

I used to notice huge improvements in plans when increasing statistics in relevant columns, as already suggested by David, and also by lowering random_page_cost, especially in older Pg versions. 

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

Предыдущее
От: David Rowley
Дата:
Сообщение: Re: Plan selection based on worst case scenario
Следующее
От: Satalabaha Postgres
Дата:
Сообщение: query column in pg_stat_statements and pg_stat_activity