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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
