Re: Help with performance problems - Mailing list pgsql-performance

From Tom Lane
Subject Re: Help with performance problems
Date
Msg-id 6865.1082775504@sss.pgh.pa.us
Whole thread Raw
In response to Help with performance problems  ("Chris Hoover" <revoohc@sermonaudio.com>)
Responses Re: Help with performance problems  ("Chris Hoover" <revoohc@sermonaudio.com>)
List pgsql-performance
"Chris Hoover" <revoohc@sermonaudio.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

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Setting Shared Buffers , Effective Cache, Sort Mem
Next
From: Rod Taylor
Date:
Subject: Re: order by index, and inheritance