2012/11/26 Ranjeet Dhumal <jeetu.dhumal@xxxxxxxxx>: > 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 ? you have to use full vacuum Regards Pavel > > > On 26 November 2012 12:09, Pavel Stehule <pavel.stehule@xxxxxxxxx> wrote: >> >> Hello >> >> 2012/11/26 Ranjeet Dhumal <jeetu.dhumal@xxxxxxxxx>: >> > 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 > > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
