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