From: Mark Lonsdale <mark.lonsdale@wysdm.com>
To: Joshua D. Drake <jd@commandprompt.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Configuration Issue ?
Date: Wed, 25 Oct 2006 16:57:09 -0400
Message-ID: <673ECBB77DA91F47AD4902A5FD73BCE4BA3A94@mail3> (raw)
Hi Josh
Thanks for the feedback, that is most usefull. When you said one of the
settings was likely killing us, was it all of the settings for
max_fsm_relations, max_fsm_pages, and sort_mem or just the setting for
sort_mem ?
Can you explain why the setting would be killing me :-)
Thanks
Mark
-----Original Message-----
From: Joshua D. Drake [mailto:jd@commandprompt.com]
Sent: 25 October 2006 21:52
To: Mark Lonsdale
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Configuration Issue ?
Mark Lonsdale wrote:
>
>
> Hi
>
>
>
> Please help. I have got a postgres 7.3.4 database running on RedHat
ES
> 3, with 8GB of physical memory in it. The machine is shared with my
> application which is pretty intensive in doing selects and updates
> against the database, but there are usually no more than 10
connections
> to the database at any time.
>
>
> shared_buffers = 393216 # min max_connections*2 or 16, 8KB
each
The above is likely hurting you more than helping you with 7.3.
>
> max_fsm_relations = 10000 # min 10, fsm is free space map, ~40
> bytes
>
> max_fsm_pages = 160001 # min 1000, fsm is free space map, ~6
>
> bytes
>
> sort_mem = 409600 # min 64, size in KB
The above will likely kill you :). Try 4096 or 8192, maybe 16384
depending on workload.
>
> vacuum_mem = 81920 # min 1024, size in KB
This is fine.
>
> Also if you have any recommendations regarding effective_cache_size Id
> be interested as reading around this sounds important as well
About 20-25% of available ram for 7.3.
The long and short is you need to upgrade to at least 7.4, preferrably
8.1.
Joshua D. Drake
>
>
>
> Thanks
>
>
>
> Mark
>
>
>
>
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
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: mark.lonsdale@wysdm.com, jd@commandprompt.com
Subject: Re: Configuration Issue ?
In-Reply-To: <673ECBB77DA91F47AD4902A5FD73BCE4BA3A94@mail3>
* 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