Hi all,
I have a large dataset and I have crawled it two and three times; hence
reltuples has increased. So I need some way to find out vacuum is needed on the
system.
Please help me in finding out some parameter or statistics which will tell me
vacuum is required on the database.
Regards,
A
Please let me know the query to get freepsace associated with all the relations
after installation of pg_freespacemap.
Regards,
Anjali
--- On Wed, 19/12/12, Glyn Astill wrote:
From: Glyn Astill
Subject: Re: [GENERAL] Vacuum analyze verbose output
To: "Anjali Arora" , &quo
Thanks a lot Glyn.
--- On Wed, 19/12/12, Glyn Astill wrote:
From: Glyn Astill
Subject: Re: [GENERAL] Vacuum analyze verbose output
To: "Anjali Arora" , "pgsql-general@postgresql.org"
Date: Wednesday, 19 December, 2012, 3:19 PM
> From: Anjali Arora
>To: pgsql-gen
Hi all,
I ran following command on 8.2.2 postgresql:
psql -p port dbname -c "vacuum analyze verbose"
last few lines from "vacuum analyze verbose" output:
DETAIL: A total of 2336 page slots are in use (including overhead).2336 page
slots are required to track all free space.Current limits are: 1
