From: Josh Berkus <josh@agliodbs.com>
To: paul@oxton.com
Cc: pgsql-performance@postgresql.org
Subject: Re: Solaris 9 tuning
Date: Mon, 7 Feb 2005 18:22:42 -0800
Message-ID: <200502071822.42805.josh@agliodbs.com> (raw)
In-Reply-To: <3834.81.134.31.64.1107815117.squirrel@www.gradwell.com>
References: <3834.81.134.31.64.1107815117.squirrel@www.gradwell.com>
Paul,
> I would like to know what /etc/system and postgresql_conf values are
> recommended to deliver as much system resource as possible to Postgres. We
> use this Sun box solely for single user Postgres data warehousing
> workloads.
What's your disk system?
> shared_buffers = 500000
This is highly unlikely to be optimal. That's 3GB. On test linux systems
up to 8GB, we've not seen useful values of shared buffers anywhere above
400mb. How did you arrive at that figure?
> sort_mem = 2097152
> vacuum_mem = 1000000
These could be fine on a single-user system. sort_mem is per *sort* though,
not per query, so you'd need to watch out for complex queries spillling into
swap; perhaps set it a 0.5GB or 1GB?
Otherwise, start with the config guide at www.powerpostgresql.com/PerfList
--
Josh Berkus
Aglio Database Solutions
San Francisco
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: josh@agliodbs.com, paul@oxton.com
Subject: Re: Solaris 9 tuning
In-Reply-To: <200502071822.42805.josh@agliodbs.com>
* 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