Skip site navigation (1) Skip section navigation (2)

Re: Vacuum and FSM page size

From: Vivek Khera <khera(at)kcilink(dot)com>
To: pgsql-performance Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Vacuum and FSM page size
Date: 2008-01-23 19:22:20
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
On Jan 23, 2008, at 1:29 PM, Thomas Lozza wrote:

> We have an installation of Postgres 8.1.2 (32bit on Solaris 9) with  
> a DB
> size of about 250GB on disk. The DB is subject to fair amount of
> inserts, deletes and updates per day.
> Running VACUUM VERBOSE tells me that I should allocate around 20M  
> pages
> to FSM (max_fsm_pages)! This looks like a really large amount to me.
> Has anyone gone ever that high with max_fsm_pages?

wow.  you must have a *lot* of pages with empty space in them....

it sounds to me like your autovacuum is not running frequently enough.

In response to


pgsql-performance by date

Next:From: Guy RouillierDate: 2008-01-23 19:57:09
Subject: Re: Making the most of memory?
Previous:From: RichDate: 2008-01-23 19:06:02
Subject: Re: Making the most of memory?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group