Re: Need to run CLUSTER to keep performance

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Need to run CLUSTER to keep performance
Дата
Msg-id dcc563d10711120904v1b868386yfd60ac2c4fe9b0f9@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Need to run CLUSTER to keep performance  (Heikki Linnakangas <heikki@enterprisedb.com>)
Ответы Re: Need to run CLUSTER to keep performance  (Heikki Linnakangas <heikki@enterprisedb.com>)
Список pgsql-performance
On Nov 12, 2007 11:01 AM, Heikki Linnakangas <heikki@enterprisedb.com> wrote:
>
> Scott Marlowe wrote:
> > So, between the first and second vacuum you had a long running
> > transaction that finally ended and let you clean up the dead rows.
>
> No, before 8.3, CLUSTER throws away non-removable dead tuples. So the
> long running transaction might still be there.

Wow, good to know.  Why would it have changed in 8.3?  Was it
considered broken behaviour?

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

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Need to run CLUSTER to keep performance
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Need to run CLUSTER to keep performance