Обсуждение: 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. Thanks, Anjali |
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
> 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 andmax_fsm_relations See: http://www.postgresql.org/docs/8.4/static/release-8-4.html
| Thanks a lot Glyn. --- On Wed, 19/12/12, Glyn Astill <glynastill@yahoo.co.uk> wrote:
|
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:
|