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

help / color / mirror / Atom feed
From: Craig Ringer <craig@postnewspapers.com.au>
To: Scott Carey <scott@richrelevance.com>
Cc: Kevin Grittner <Kevin.Grittner@wicourts.gov>
Cc: Madison Kelly <linux@alteeve.com>
Cc: Gary Doades <gpd@gpdnet.co.uk>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: DB is slow until DB is reloaded
Date: Wed, 06 Jan 2010 09:16:47 +0800
Message-ID: <4B43E47F.5010305@postnewspapers.com.au> (raw)
In-Reply-To: <BDFBB77C9E07BE4A984DAAE981D19F9652E316749E@EXVMBX018-1.exch018.msoutlookonline.net>
References: <4B423D22.7040803@alteeve.com>
	<4B424215.70605@pinpointresearch.com>
	<4B424FF6.40207@alteeve.com>
	<4B425222.7070905@gpdnet.co.uk>
	<4B425555.6020709@alteeve.com>
	<4B420354020000250002DCC4@gw.wicourts.gov>
	<BDFBB77C9E07BE4A984DAAE981D19F9652E316749E@EXVMBX018-1.exch018.msoutlookonline.net>

Scott Carey wrote:
> CLUSTER also does *nothing at all* to a table unless you have chosen an index to CLUSTER on.  Its not as simple as switching from VACUUM or VACUUM FULL to CLUSTER.
> 
> Does CLUSTER also REINDEX? I seem to recall reducing the size of my indexes by REINDEXing after a CLUSTER, but it was a while ago and I could have been mistaken.

AFAIK CLUSTER builds a new copy of the table, and new indexes for it,
then swaps them into the old table and index's place.

--
Craig Ringer



view thread (25+ messages)

Message-ID: <4B43E47F.5010305@postnewspapers.com.au>
Permalink:  ../4B43E47F.5010305@postnewspapers.com.au/
Also on:    postgresql.org/message-id/4B43E47F.5010305@postnewspapers.com.au

 · 

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: craig@postnewspapers.com.au, scott@richrelevance.com, Kevin.Grittner@wicourts.gov, linux@alteeve.com, gpd@gpdnet.co.uk
  Subject: Re: DB is slow until DB is reloaded
  In-Reply-To: <4B43E47F.5010305@postnewspapers.com.au>

* 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