Hi Pavel , For Tunning this which parameter i have to change from the configuration , and at the time of setting it up which thinks i have to care i mean what will be the impact of that ?
On 26 November 2012 12:09, Pavel Stehule <pavel.steh...@gmail.com> wrote: > Hello > > 2012/11/26 Ranjeet Dhumal <jeetu.dhu...@gmail.com>: > > Hi All , > > > > Am facing one problem related to pg_toast table , its grown very huge > upto > > 31GB , even am vacuuming(not full) it daily , my fsm parameters are > default, > > can anyone tell how to decrease the size , if am firing any query on > > gen_bulk_20121126 its response time is very slow as compared to few days > > before . > > For changing fsm parameters it will need restart , can anyone suggest me > any > > other way for decreasing the size of this pg_toast tables. > > > > lazy vacuum doesn't decrease size > > Regards > > Pavel Stehule > > > > > nspname | relname > > | size | refrelname | > > relidxrefrelname | relfilenode | relkind | reltuples | > > relpages > > > -----------------------------------------+----------------------------------------------------------------+------------+-----------------------------------------------+-----------------------------------------------+------------------+-----------+----------------+---------- > > pg_toast | pg_toast_123049508 > > | 31 GB | gen_bulk_20121126 | > > | 123049512 | t | 16340229 | 4051494 > > > > > > -- > > --Regards > > Ranjeet R. Dhumal > > > > > -- --Regards Ranjeet R. Dhumal
