Re: Avoiding out of date statistics / planner

Поиск
Список
Период
Сортировка
От Michael Lewis
Тема Re: Avoiding out of date statistics / planner
Дата
Msg-id CAHOFxGoLmmZCkP=zMpV7mTJk5Rqhprtw=rQkj6-bWK5ZwQMLUw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Avoiding out of date statistics / planner  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Avoiding out of date statistics / planner
Список pgsql-general
It may also be worth noting that it is possible to make autovacuum/analyze more aggressive, perhaps only on the tables that see large changes in data that might result in a statistics issue. If you could share a query, explain analyze output, and pseudo code or at least description of what sort of bulk operations are being done, then more insight could be offered.

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

Предыдущее
От: Dmitry Igrishin
Дата:
Сообщение: Re: Natural sort order extension.
Следующее
От: Andres Freund
Дата:
Сообщение: Re: JIT on Windows with Postgres 12.1