Re: Help with performance problems

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Help with performance problems
Дата
Msg-id 6865.1082775504@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Help with performance problems  ("Chris Hoover" <revoohc@sermonaudio.com>)
Ответы Re: Help with performance problems
Список pgsql-performance
"Chris Hoover" <revoohc@sermonaudio.com> writes:
> Here is the postgresql.conf from the server with the 11GB db:

> max_fsm_pages = 10000        # min 1000, fsm is free space map, ~6 bytes

It's unlikely that that's enough for an 11Gb database, especially if
you're only vacuuming a few times a week.  You should make your next run
be a "vacuum verbose" and look at the output to get an idea of what sort
of table bloat you're seeing, but I'll bet it's bad ...

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Setting Shared Buffers , Effective Cache, Sort Mem
Следующее
От: Rod Taylor
Дата:
Сообщение: Re: order by index, and inheritance