Re: Need to run CLUSTER to keep performance

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>
Cc: "Rafael Martinez" <r(dot)m(dot)guerrero(at)usit(dot)uio(dot)no>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Need to run CLUSTER to keep performance
Date: 2007-11-12 17:04:44
Message-ID: dcc563d10711120904v1b868386yfd60ac2c4fe9b0f9@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Nov 12, 2007 11:01 AM, Heikki Linnakangas <heikki(at)enterprisedb(dot)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?

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Heikki Linnakangas 2007-11-12 18:03:16 Re: Need to run CLUSTER to keep performance
Previous Message Heikki Linnakangas 2007-11-12 17:01:19 Re: Need to run CLUSTER to keep performance