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

Re: Help with performance problems

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Chris Hoover" <revoohc(at)sermonaudio(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Help with performance problems
Date: 2004-04-24 02:58:24
Message-ID: 6865.1082775504@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
"Chris Hoover" <revoohc(at)sermonaudio(dot)com> writes:
> Here is the postgresql.conf from the server with the 11GB db:

> max_fsm_pages = 10000		# min 1000, fsm is free space map, ~6 bytes

It's unlikely that that's enough for an 11Gb database, especially if
you're only vacuuming a few times a week.  You should make your next run
be a "vacuum verbose" and look at the output to get an idea of what sort
of table bloat you're seeing, but I'll bet it's bad ...

			regards, tom lane

In response to

Responses

pgsql-performance by date

Next:From: Shea,Dan [CIS]Date: 2004-04-24 14:45:40
Subject: Re: Why will vacuum not end?
Previous:From: Tom LaneDate: 2004-04-24 02:50:14
Subject: Re: Setting Shared Buffers , Effective Cache, Sort Mem

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