On Tue, 24 Dec 2019 at 02:41, Peter Geoghegan <p...@bowt.ie> wrote: > > On Mon, Dec 23, 2019 at 11:05 AM Mahendra Singh <mahi6...@gmail.com> wrote: > > From above example, we can see that after deleting all the tuples from > > table and firing vacuum command, size of table is reduced but size of index > > relation is same as before vacuum. > > VACUUM is only able to make existing empty pages in indexes recyclable > by future page splits within the same index. It is not possible for it > to reclaim space for the filesystem. Workload characteristics tend to > determine whether or not this limitation is truly important.
Thank you for the clarification. Thanks and Regards Mahendra Singh Thalor EnterpriseDB: http://www.enterprisedb.com
