Home > mailing lists

where is max_fsm_pages in PG9.0? - Mailing list pgsql-performance

From	Anibal David Acosta
Subject	where is max_fsm_pages in PG9.0?
Date	September 20, 2011 04:28:55
Msg-id	000301cc774d$c9ec3770$5dc4a650$@devshock.com Whole thread Raw
Responses	Re: where is max_fsm_pages in PG9.0? (Scott Marlowe <scott.marlowe@gmail.com>)
List	pgsql-performance

I have a lot of wasted bytes in some tables.

Somewhere I read that maybe auto-vacuum can’t release space due to a low max_fsm_pages setting.

I want to increase it, but I don’t found the param in the postgres.conf.

This param exists? If not? How can I deal with bloated tables?

I have many tables with lot of insert/updates/delete (aprox. 5,000,000 per day)

Thanks!

From: Stephen Frost
Date: 20 September 2011, 01:32:48
Subject: Re: Postgres INSERT performance and scalability

From: Scott Marlowe
Date: 20 September 2011, 04:49:58
Subject: Re: where is max_fsm_pages in PG9.0?