Re: database file size bloat

Поиск
Список
Период
Сортировка
От Ed Loehr
Тема Re: database file size bloat
Дата
Msg-id 38F73692.E28C9AD7@austin.rr.com
обсуждение исходный текст
Ответ на Re: database file size bloat  (Matthew Arnison <matthewa@physics.usyd.edu.au>)
Список pgsql-general
Matthew Arnison wrote:
>
> the bloat is a big problem. i just checked it again, and the db has
> balloooned to 20 megs again, with i think 2650 unused pages. this is after
> vacuuming it last night. i guess we need to setup the vacuum script to run
> every hour. i am worried about this locking out users during the
> vacuuming, although i guess if it happens more often, it should take less
> time.

I should add that my vacuum runs don't take very long (< 10 seconds).  I
would have to consider other alternatives if it took much longer...

> meanwhile, as for upgrading, i think i'll try 6.5.3 first.
>
> version 7 is still in beta. is it atleast as stable as 6.5.3? is it
> atleast as fast as 6.5.3?

Beta3 is more stable and much faster, IMO.  Haven't tried beta5.

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

Предыдущее
От: A James Lewis
Дата:
Сообщение: Parallel databases?
Следующее
От: Ed Loehr
Дата:
Сообщение: Re: Postgresqlism & Vacuum?