Re: Vacuum analyze verbose output

From: Anjali Arora <anjali_524(at)yahoo(dot)co(dot)in>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>, Glyn Astill <glynastill(at)yahoo(dot)co(dot)uk>
Subject: Re: Vacuum analyze verbose output
Date: 2012-12-24 07:27:25
Message-ID: 1356334045.74704.YahooMailClassic@web192203.mail.sg3.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 <glynastill(at)yahoo(dot)co(dot)uk> wrote:

From: Glyn Astill <glynastill(at)yahoo(dot)co(dot)uk>
Subject: Re: [GENERAL] Vacuum analyze verbose output
To: "Anjali Arora" <anjali_524(at)yahoo(dot)co(dot)in>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Date: Wednesday, 19 December, 2012, 3:19 PM

> From: Anjali Arora <anjali_524(at)yahoo(dot)co(dot)in>

>To: pgsql-general(at)postgresql(dot)org
>Sent: Wednesday, 19 December 2012, 9:14
>Subject: [GENERAL] Vacuum analyze verbose output
>
>
>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:  153600 page slots, 1000 relations, using 965 kB.
>
>
>After upgrade to postgresql 9.0.4 I am not getting this output as the part of "vacuum analyze verbose" output.
>
>
>Can anybody please let me know where can I find this information in postgresql 9.0.4.

I'm not sure you can, as of 8.4 free space tracking was made automatic, so you no longer need to track max_fsm_pages and max_fsm_relations

See: http://www.postgresql.org/docs/8.4/static/release-8-4.html

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Atri Sharma 2012-12-24 07:50:50 pgbench help
Previous Message John R Pierce 2012-12-24 03:43:48 Re: logger table