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 > > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
