Thanks a lot Glyn. --- On Wed, 19/12/12, Glyn Astill <glynast...@yahoo.co.uk> wrote:
From: Glyn Astill <glynast...@yahoo.co.uk> Subject: Re: [GENERAL] Vacuum analyze verbose output To: "Anjali Arora" <anjali_...@yahoo.co.in>, "pgsql-general@postgresql.org" <pgsql-general@postgresql.org> Date: Wednesday, 19 December, 2012, 3:19 PM > From: Anjali Arora <anjali_...@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
