Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Mon, 12 Nov 2007 11:04:44 -0600
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?
- Follow-Ups:
- Re: Need to run CLUSTER to keep performance
- From: Heikki Linnakangas
- Re: Need to run CLUSTER to keep performance
- References:
- Need to run CLUSTER to keep performance
- From: Rafael Martinez
- Re: Need to run CLUSTER to keep performance
- From: Heikki Linnakangas
- Re: Need to run CLUSTER to keep performance
- From: Rafael Martinez
- Re: Need to run CLUSTER to keep performance
- From: Tom Lane
- Re: Need to run CLUSTER to keep performance
- From: Rafael Martinez
- Re: Need to run CLUSTER to keep performance
- From: Rafael Martinez
- Re: Need to run CLUSTER to keep performance
- From: Scott Marlowe
- Re: Need to run CLUSTER to keep performance
- From: Heikki Linnakangas
- Need to run CLUSTER to keep performance
- Prev by Date: Re: Need to run CLUSTER to keep performance
- Next by Date: Re: Need to run CLUSTER to keep performance
- Previous by thread: Re: Need to run CLUSTER to keep performance
- Next by thread: Re: Need to run CLUSTER to keep performance
- Indexes: