Re: Autovacuum / full vacuum

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Autovacuum / full vacuum
Дата
Msg-id 28618.1137512171@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Autovacuum / full vacuum  (Michael Riess <mlriess@gmx.de>)
Список pgsql-performance
Michael Riess <mlriess@gmx.de> writes:
> But actually I never understood why the database system slows down at
> all when there is much unused space in the files.

Perhaps some of your common queries are doing sequential scans?  Those
would visit the empty pages as well as the full ones.

            regards, tom lane

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

Предыдущее
От: Andrew Sullivan
Дата:
Сообщение: Re: Autovacuum / full vacuum
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: Autovacuum / full vacuum