Re: [GENERAL] Vacuum analyze verbose output

2012-12-23 Thread Anjali Arora
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

Re: [GENERAL] Vacuum analyze verbose output

2012-12-20 Thread Anjali Arora
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

Re: [GENERAL] Vacuum analyze verbose output

2012-12-19 Thread Glyn Astill
> From: Anjali Arora >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 "vacu

Re: [GENERAL] Vacuum analyze verbose output

2012-12-19 Thread Albe Laurenz
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 spa

[GENERAL] Vacuum analyze verbose output

2012-12-19 Thread Anjali Arora
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