Re: Issue with pg_toast tables

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(dot)stehule(at)gmail(dot)com> wrote:

> Hello
>
> 2012/11/26 Ranjeet Dhumal <jeetu(dot)dhumal(at)gmail(dot)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