pg_toast size - Mailing list pgsql-performance

From Julien Drouard
Subject pg_toast size
Date
Msg-id 000c01c65fc5$41c78a70$0700a8c0@ankama.lan
Whole thread Raw
Responses Re: pg_toast size  ("Jim C. Nasby" <jnasby@pervasive.com>)
List pgsql-performance
Hi everyone,
 
I've seen my pg_toast tables are becoming bigger and bigger. After googling I would like to modify my max_fsm_pages parameter to prevent that kind of problem. So I'm wondering if changing this parameter is enough and after that how can I reduce the size of these tables? By doing a full vacuum?
 
Thanks in advance,
 
Julien

pgsql-performance by date:

Previous
From: Marc Cousin
Date:
Subject: Re: Inserts optimization?
Next
From: "Jignesh K. Shah"
Date:
Subject: Re: bad performance on Solaris 10