Skip site navigation (1) Skip section navigation (2)

Reindex - Is this necessary after a vacuum?

From: Markus Benne <thing(at)m-bass(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Reindex - Is this necessary after a vacuum?
Date: 2005-10-25 13:56:07
Message-ID: 20051025135607.39805.qmail@web31615.mail.mud.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-performance
We are reindexing frequently, and I'm wondering if
this is really necessary, given that it appears to
take an exclusive lock on the table.

Our table in question is vacuumed every 4 minutes, and
we are reindexing after each one.

I'm not a fan of locking this table that frequently,
even if it is only for 5 - 10 seconds depending on
load.

The vacuum is a standard vacuum.  Nightly we do a
vacuum analyze.

Thanks for any tips,
...Markus

Responses

pgsql-performance by date

Next:From: Michael StoneDate: 2005-10-25 14:05:49
Subject: Re: insertion of bytea
Previous:From: Chris MairDate: 2005-10-25 13:44:36
Subject: insertion of bytea

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group