Re: Adding more space, and a vacuum question.
| От | Herouth Maoz |
|---|---|
| Тема | Re: Adding more space, and a vacuum question. |
| Дата | |
| Msg-id | 06D135DE-B482-4161-9C5B-16652886085D@unicell.co.il обсуждение исходный текст |
| Ответ на | Adding more space, and a vacuum question. ("Herouth Maoz" <herouth@unicell.co.il>) |
| Ответы |
Re: Adding more space, and a vacuum question.
Re: Adding more space, and a vacuum question. |
| Список | pgsql-general |
On 30/01/2011, at 12:27, Craig Ringer wrote:
OK, so you're pre-8.4 , which means you have the max_fsm settings to play with. Have you seen any messages in the logs about the free space map (fsm)? If your install didn't have a big enough fsm to keep track of deleted tuples, you'd face massive table bloat that a regular vacuum couldn't fix.
You also don't have the visibility map, which means that (auto)vacuum can't skip bits of the tables it knows don't need vacuuming. Your vacuums will be slower.
Autovacuum improved significantly in both 8.4 and 9.0; consider an upgrade.
Herouth
В списке pgsql-general по дате отправления: