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.
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
