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: (view raw, whole thread or download thread mbox)
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

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

Thanks for any tips,


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-2017 The PostgreSQL Global Development Group