Re: Space occupied by Postgres index.
От | Kenneth Marshall |
---|---|
Тема | Re: Space occupied by Postgres index. |
Дата | |
Msg-id | 20101130172841.GK19162@aart.is.rice.edu обсуждение исходный текст |
Ответ на | Space occupied by Postgres index. ("Shridhar Polas" <shridharpolas@gmail.com>) |
Ответы |
Re: Space occupied by Postgres index.
|
Список | pgsql-admin |
On Tue, Nov 30, 2010 at 10:56:53PM +0530, Shridhar Polas wrote: > Hi, > > > > I am facing a problem where indexes creates on some tables are occupying > huge space on disk and it seems to me that this space is not getting > reclaimed even when there are very few record in an associated table. > > > > When I ran full vacuum the disk space was reclaimed occupied by tables but > not by disk space occupied by indexes. > > > > Can somebody please tell me when disk space occupied by Postgres index is > reclaimed, without performing re-indexing on those tables? > > > > Thanks, > > Shridhar > VACUUM FULL will cause index bloat. You will need to REINDEX to recover the space. Note, you should not really need to use VACUUM FULL in a normal correctly configured system. Cheers, Ken
В списке pgsql-admin по дате отправления: