| From: | Ranjeet Dhumal <jeetu(dot)dhumal(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Issue with pg_toast tables |
| Date: | 2012-11-26 06:36:13 |
| Message-ID: | CAFNnw=1Ay7BWgaMNb_YuW2sbxRrM96eyixM_PGNtJ5=aGA5N2A@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2012-11-26 06:39:22 | Re: Issue with pg_toast tables |
| Previous Message | Tom Lane | 2012-11-26 06:14:57 | Re: Regarding getting source from 9.2.0beta1 and 9.2beta1. |