DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=references:in-reply-to:mime-version:content-transfer-encoding
	:content-type:message-id:cc:x-mailer:from:subject:date:to;
	b=OMVgePghnPb/adAA3sOdIdx5I0ZGW57fZezRRAD/XfIIbyOiXlu6vUbQybbvFHI5Tt
	MD3JWMerjnop6uxyEmzlnoLg0Q6Z12i6XDk5zqKSRtCeQQfcWRaTIkydyd5eDBUQ9606
	gJ5Pqs+NRdAsYqNTXwHc02V+Uf17R5eYYuQMw=
References: <AANLkTim1aO2hG+D4h_VFXas8GTL6TQMLj7aDc7tJ0vok@mail.gmail.com>
	<AANLkTinjsS7Aj0ZoMVq3ZDhKepBsZ_HOpBqEjRrabk_J@mail.gmail.com>
	<BANLkTinq7KSstviqjGfnaKh7YOfan7sjig@mail.gmail.com>
In-Reply-To: <BANLkTinq7KSstviqjGfnaKh7YOfan7sjig@mail.gmail.com>
Mime-Version: 1.0 (iPhone Mail 8A293)
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=us-ascii
Message-Id: <34CE0668-2A83-4BE4-B191-86871C2F8334@gmail.com>
Cc: Merlin Moncure <mmoncure@gmail.com>,
	"pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
From: Robert Haas <robertmhaas@gmail.com>
Subject: Re: REINDEX takes half a day (and still not complete!)
Date: Sat, 23 Apr 2011 15:44:23 -0400
To: Phoenix Kiula <phoenix.kiula@gmail.com>

On Apr 17, 2011, at 11:30 AM, Phoenix Kiula <phoenix.kiula@gmail.com> wrote:=

> Sorry, rejuvenating a thread that was basically unanswered.
>=20
> I closed the database for any kinds of access to focus on maintenance
> operations, killed all earlier processes so that my maintenance is the
> only stuff going on.
>=20
> REINDEX is still taking 3 hours -- and it is still not finished!
>=20
> Similarly, if I cancel the REINDEX and issue a VACUUM ANALYZE VERBOSE,
> this too seems to just hang there on my big table.
>=20
> I changed the maintenance_work_men to 2GB for this operation. It's
> highly worrisome -- the above slow times are with 2GB of my server
> dedicated to Postgresql!!!!
>=20
> Surely this is not tenable for enterprise environments? I am on a
> 64bit RedHat server with dual CPU Intel Woodcrest or whatever that was
> called. Postgres is 8.2.9.
>=20
> How do DB folks do this with small maintenance windows? This is for a
> very high traffic website so it's beginning to get embarrassing.
>=20
> Would appreciate any thoughts or pointers.

An upgrade would probably help you a lot, and as others have said it sounds l=
ike your hardware is failing, so you probably want to deal with that first.

I am a bit surprised, however, that no one seems to have mentioned using CLU=
STER rather than VACUUM or REINDEX. Sometimes that's worth a try...

...Robert=