Re: [Solved] Postgres performance problem

Поиск
Список
Период
Сортировка
От Vivek Khera
Тема Re: [Solved] Postgres performance problem
Дата
Msg-id BB0FC482-905A-4E97-B81B-A6E21AE80CD4@khera.org
обсуждение исходный текст
Ответ на Re: [Solved] Postgres performance problem  (Mark Lewis <mark.lewis@mir3.com>)
Список pgsql-performance
On Aug 30, 2007, at 2:08 PM, Mark Lewis wrote:

> If you're not running regular VACUUMs at all but are instead
> exclusively
> running VACUUM FULL, then I don't think you would see warnings about
> running out of fsm enties, which would explain why you did not notice
> the bloat.  I haven't confirmed that though, so I might be wrong.

If you run vacuum full, your pages should be full so there should be
very small if any number of pages in the free space map.  Thus, there
would be no warnings.


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

Предыдущее
От: Erik Jones
Дата:
Сообщение: Re: 8.2 Autovacuum BUG ?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: 8.2 Autovacuum BUG ?