Space occupied by Postgres index. - Mailing list pgsql-admin

From Shridhar Polas
Subject Space occupied by Postgres index.
Date
Msg-id 00b901cb90b3$ca9ddc40$5fd994c0$@gmail.com
Whole thread Raw
Responses Re: Space occupied by Postgres index.
List pgsql-admin

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

pgsql-admin by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Postgres service won't start, doesn't log any errors
Next
From: Kenneth Marshall
Date:
Subject: Re: Space occupied by Postgres index.