pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Heikki Linnakangas <heikki@enterprisedb.com>
To: Scott Marlowe <scott.marlowe@gmail.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 18:03:16 +0000
Message-ID: <47389564.6010602@enterprisedb.com> (raw)
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>

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



view thread (21+ messages)  latest in thread

Message-ID: <47389564.6010602@enterprisedb.com>
Permalink:  ../47389564.6010602@enterprisedb.com/
Also on:    postgresql.org/message-id/47389564.6010602@enterprisedb.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 using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: heikki@enterprisedb.com, scott.marlowe@gmail.com, r.m.guerrero@usit.uio.no, tgl@sss.pgh.pa.us
  Subject: Re: Need to run CLUSTER to keep performance
  In-Reply-To: <47389564.6010602@enterprisedb.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