Re: Table bloat and vacuum

Поиск
Список
Период
Сортировка
От Adriana Alfonzo
Тема Re: Table bloat and vacuum
Дата
Msg-id 491AF1F5.4000109@venalum.com.ve
обсуждение исходный текст
Ответ на Re: Table bloat and vacuum  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Ответы Re: Table bloat and vacuum  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-general
Please, i wan't recive more mails....

Thanks

Scott Marlowe escribió:
> On Wed, Nov 12, 2008 at 8:13 AM, Jack Orenstein <jack.orenstein@hds.com> wrote:
>
>> My application is running on 7.4. We have one huge table that drives
>>
> SNIP
>
>> We're in the process of upgrading to 8.3.4, so I'd appreciate any
>> throughs on whether and how this behavior will change with the newer
>> release.
>>
>
> You will not believe how much faster 8.3 is, and how much easier
> maintenance is.  You'll be like a kid in a candy store for months
> looking at and using all the new features in it.  The improvements are
> enormous.  Biggest difference for you is that 8.3 can do vacuums in a
> background method (it sleeps x milliseconds between pages), can run 3
> or more threads, and autovacuum daemon is on by default.  For the most
> part, your vacuuming issues will no longer exist.
>
>

Aviso Legal  Este mensaje puede contener informacion de interes solo para CVG Venalum. Solo esta permitida su copia,
distribuciono uso a personas autorizadas. Si recibio este corre por error, por favor destruyalo. Eventualmentew los
correoselectonicos pueden ser alterados. Al respecto, CVG Venalum no se hace responsable por los errores que pudieran
afectaral mensaje original. 

Вложения

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

Предыдущее
От: "Scott Marlowe"
Дата:
Сообщение: Re: Table bloat and vacuum
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: Very slow queries w/ NOT IN preparation (seems like a bug, test case)