Shankar,
> Is there a better way to do this. comments are
> appreciated.
No. This is one of the major features in 7.4; FSM and VACUUM will manage
indexes as well. Until then, we all suffer
BTW, the REINDEX command is transaction-safe. So if your database has "lull"
periods, you can r
Hi Everyone,
I've a kind of less inserts/mostly updates table,
which we vacuum every half-hour.
here is the output of vacuum analyze
INFO: --Relation public.accounts--
INFO: Index accounts_u1: Pages 1498; Tuples 515:
Deleted 179.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
INFO: Index acc
