| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | DANTE Alexandra <Alexandra(dot)Dante(at)bull(dot)net> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: VACUUM and index |
| Date: | 2006-07-19 13:13:19 |
| Message-ID: | 20060719131319.GA6893@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Jul 19, 2006 at 03:03:43PM +0200, DANTE Alexandra wrote:
> Imagine you have a database on which a lot of transactions are done
> daily : the tables will contain a lot of dead tuples and the B-tree
> index too.
>
> If I do a VACUUM on this database, will the B-tree index be scanned,
> space reclaimed and made available for re-use ?
Old versions didn't, but recent versions do.
> Does this action only do by a VACUUM FULL ?
Also by VACUUM FULL, but plain VACIIM is enough.
> Or is it necessary to do a REINDEX on the index to retrieve a
> well-balanced tree ?
There are always corner case situations. In older versions a REINDEX
helped balance the tree but recent versions are much better.
Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Timothy Smith | 2006-07-19 13:16:38 | Re: problem creating users via pythons script |
| Previous Message | DANTE Alexandra | 2006-07-19 13:03:43 | VACUUM and index |