Know bloat percentage after auto vacuum - Mailing list pgsql-admin

From satish v
Subject Know bloat percentage after auto vacuum
Date
Msg-id CAPG-CvVyZEY6tjsEKJXZBW69pmWpaMrbf7TbnM3yQqBCU3tUow@mail.gmail.com
Whole thread Raw
Responses Re: Know bloat percentage after auto vacuum  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-admin
Hi all.

We have the table with 2 months data (approx 450GB). We deleted 17 days of data and auto vacuum performed on the table.new insertions are utilizing  that space,we want to perform the vacuum full and reclaim the space at os level but don't know how much free (unused) space available.how can we get the details.

Thanks in advance.

Regards,
Satish.

pgsql-admin by date:

Previous
From: Tyler Brock
Date:
Subject: Re: Segfault during queries
Next
From: Laurenz Albe
Date:
Subject: Re: Know bloat percentage after auto vacuum