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: E7A5FF07-C603-4B4C-ABC7-C280109E3351@kcilink.com (view raw or flat)
Thread:
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

Responses

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-2014 The PostgreSQL Global Development Group