pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Scott Marlowe <scott.marlowe@gmail.com>
To: Heikki Linnakangas <heikki@enterprisedb.com>
Cc: Rafael Martinez <r.m.guerrero@usit.uio.no>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-performance@postgresql.org
Subject: Re: Need to run CLUSTER to keep performance
Date: Mon, 12 Nov 2007 11:04:44 -0600
Message-ID: <dcc563d10711120904v1b868386yfd60ac2c4fe9b0f9@mail.gmail.com> (raw)
In-Reply-To: <473886DF.1050902@enterprisedb.com>
References: <4732E6B4.1030907@usit.uio.no>
	<4732EF07.3060807@enterprisedb.com>
	<47332200.9050705@usit.uio.no>
	<24775.1194535980@sss.pgh.pa.us>
	<4738735B.6030408@usit.uio.no>
	<47387B4F.7000608@usit.uio.no>
	<dcc563d10711120835q55fa3829s6d8932058ae6182e@mail.gmail.com>
	<473886DF.1050902@enterprisedb.com>

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?



view thread (21+ messages)  latest in thread

Message-ID: <dcc563d10711120904v1b868386yfd60ac2c4fe9b0f9@mail.gmail.com>
Permalink:  ../dcc563d10711120904v1b868386yfd60ac2c4fe9b0f9@mail.gmail.com/
Also on:    postgresql.org/message-id/dcc563d10711120904v1b868386yfd60ac2c4fe9b0f9@mail.gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-performance@postgresql.org
  Cc: scott.marlowe@gmail.com, heikki@enterprisedb.com, r.m.guerrero@usit.uio.no, tgl@sss.pgh.pa.us
  Subject: Re: Need to run CLUSTER to keep performance
  In-Reply-To: <dcc563d10711120904v1b868386yfd60ac2c4fe9b0f9@mail.gmail.com>
  References: <4732E6B4.1030907@usit.uio.no> <4732EF07.3060807@enterprisedb.com> <47332200.9050705@usit.uio.no> <24775.1194535980@sss.pgh.pa.us> <4738735B.6030408@usit.uio.no> <47387B4F.7000608@usit.uio.no> <dcc563d10711120835q55fa3829s6d8932058ae6182e@mail.gmail.com> <473886DF.1050902@enterprisedb.com> <dcc563d10711120904v1b868386yfd60ac2c4fe9b0f9@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox