From: Matthew Sackman <matthew@lshift.net>
To: pgsql-performance@postgresql.org
Subject: Re: Massive performance issues
Date: Thu, 1 Sep 2005 23:00:07 +0100
Message-ID: <20050901220007.GE7131@pongo.lshift.net> (raw)
In-Reply-To: <Pine.LNX.4.63.0509011420330.22330@discord.dyndns.org>
References: <20050901174231.GE23970@pongo.lshift.net>
<43176A95.70506@tweakers.net>
<20050901211359.GD7131@pongo.lshift.net>
<Pine.LNX.4.63.0509011420330.22330@discord.dyndns.org>
On Thu, Sep 01, 2005 at 02:26:47PM -0700, Jeff Frost wrote:
> >Well I've got 1GB of RAM, but from analysis of its use, a fair amount
> >isn't being used. About 50% is actually in use by applications and about
> >half of the rest is cache and the rest isn't being used. Has this to do
> >with the max_fsm_pages and max_fsm_relations settings? I've pretty much
> >not touched the configuration and it's the standard Debian package.
>
> Matt, have a look at the annotated postgresql.conf for 7.x here:
>
> http://www.varlena.com/varlena/GeneralBits/Tidbits/annotated_conf_e.html
>
> If you have the default settings, you're likely hampering yourself quite a
> bit. You probably care about shared_buffers, sort_mem,
> vacuum_mem, max_fsm_pages, effective_cache_size
That's a useful resource, thanks for the pointer. I'll work through that
tomorrow.
> Also, you may want to read the PostgreSQL 8.0 Performance Checklist. Even
> though it's for 8.0, it'll give you good ideas on what to change in 7.4.
> You can find it here: http://www.powerpostgresql.com/PerfList/
Thanks, another good resource. I'll work through that too.
Matthew
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: matthew@lshift.net
Subject: Re: Massive performance issues
In-Reply-To: <20050901220007.GE7131@pongo.lshift.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox