Vacuum analyze verbose output

Anjali Arora wrote:

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.

This output must be referring to the free space map
(parameters max_fsm_pages and max_fsm_relations)
that used to be kept in shared memory in older
PostgreSQL versions.

Since version 8.4 the free space map is no longer
kept in shared memory, but in disk files.
You don't have to tune it any more, and there is no
need for VACUUM to report usage statistics.

Yours,
Laurenz Albe

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

From: Anjali Arora <anjali_524@yahoo.co.in>

To: pgsql-general@postgresql.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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Thanks a lot Glyn.

--- On Wed, 19/12/12, Glyn Astill <glynastill@yahoo.co.uk> wrote:

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

From: Anjali Arora <anjali_524@yahoo.co.in>

To: pgsql-general@postgresql.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

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@yahoo.co.uk> wrote:

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

From: Anjali Arora <anjali_524@yahoo.co.in>

To: pgsql-general@postgresql.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