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
Thanks for any tips,
pgsql-performance by date
|Next:||From: Michael Stone||Date: 2005-10-25 14:05:49|
|Subject: Re: insertion of bytea|
|Previous:||From: Chris Mair||Date: 2005-10-25 13:44:36|
|Subject: insertion of bytea|