Re: autovacuum vacuum creates bad statistics for planner when it log index scans: 0

Поиск
Список
Период
Сортировка
От tim_wilson
Тема Re: autovacuum vacuum creates bad statistics for planner when it log index scans: 0
Дата
Msg-id 1400471776246-5804424.post@n5.nabble.com
обсуждение исходный текст
Ответ на autovacuum vacuum creates bad statistics for planner when it log index scans: 0  (tim_wilson <tim.wilson@telogis.com>)
Список pgsql-performance
Дерево обсуждения 
Just to add a little more detail about my busy_table
1) there are no rows deleted
2) 98% of updates are HOT
3) there are two DB's on this postgres instance both with the same table,
both seeing the same issue




--
View this message in context:
http://postgresql.1045698.n5.nabble.com/autovacuum-vacuum-creates-bad-statistics-for-planner-when-it-log-index-scans-0-tp5804416p5804424.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.

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

Предыдущее
От: tim_wilson
Дата:
Сообщение: autovacuum vacuum creates bad statistics for planner when it log index scans: 0
Следующее
От: Geoff Hull
Дата:
Сообщение: View has different query plan than select statement