> From: Anjali Arora <
anjali_524@xxxxxxxxxxx>
>To:
pgsql-general@xxxxxxxxxxxxxx >Sent: Wednesday, 19 December 2012,
9:14
>Subject: 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