Re: Many DataFileRead - IO waits

Поиск
Список
Период
Сортировка
От Michael Lewis
Тема Re: Many DataFileRead - IO waits
Дата
Msg-id CAHOFxGrMHhm+kGeB=DP8nYm-H2k2A5CU4gbFqWrtQtD_VETgKg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Many DataFileRead - IO waits  (Ben Snaidero <bensnaidero@geotab.com>)
Ответы Re: Many DataFileRead - IO waits  (Ben Snaidero <bensnaidero@geotab.com>)
Список pgsql-performance
If no updates or deletes are happening on the table, it would be best practice to set up a scheduled manual vacuum analyze to ensure statistics and the visibility map is updated. Other than creating the index on the first two columns only, I'm out of ideas. Hopefully someone running Postgres at large scale on Windows will chime in.

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

Предыдущее
От: Ben Snaidero
Дата:
Сообщение: Re: Many DataFileRead - IO waits
Следующее
От: Ben Snaidero
Дата:
Сообщение: Re: Many DataFileRead - IO waits