Re: Need to run CLUSTER to keep performance

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: Need to run CLUSTER to keep performance
Дата
Msg-id 47389564.6010602@enterprisedb.com
обсуждение исходный текст
Ответ на Re: Need to run CLUSTER to keep performance  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Список pgsql-performance
Scott Marlowe wrote:
> 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?

I certainly considered it broken, though it was a known issue all along.

--
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com

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

Предыдущее
От: "Scott Marlowe"
Дата:
Сообщение: Re: Need to run CLUSTER to keep performance
Следующее
От: Dave Cramer
Дата:
Сообщение: Re: difference between a unique constraint and a unique index ???