Re: Issue with pg_toast tables

On 11/25/12 10:36 PM, Ranjeet Dhumal wrote:
> 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.
>

pg_toast contains large data that won't fit in regular tuples.

this table that you're getting slow queries on, could you show us one of
these slow queries with EXPLAIN ANALYZE ? if your table has grown
significantly it could need a carefully chosen index to speed up these
queries, or something similar.

also the output of...

VACUUM VERBOSE pg_toast_123049508 ;

may be enlightening.

--
john r pierce N 37, W 122
santa cruz ca mid-left coast