From: Christian Paul B. Cosinas <cpc@cybees.com>
To: pgsql-performance@postgresql.org
Subject: Configuration Suggestion
Date: Wed, 26 Oct 2005 06:05:55 -0000
Message-ID: <000601c5d9f3$5478f260$1e21100a@ghwk02002147> (raw)
In-Reply-To: <004a01c5d9d3$28199820$1e21100a@ghwk02002147>
Hi! Here is the Specifications of My Server.
I would really appreciate the best configuration of postgresql.conf for my
sevrer.
I have tried so many value in the parameters but It seems that I cannot get
the speed I want.
OS: Redhat Linux
CPU: Dual Xeon
Memory: 6 gigabyte
PostgreSQL Version 8.0
Most of my queries are having Order by Clause, and group by clause.
Creation of temporary table.
The biggest rows is about 3-5 million which I query almost every 5 seconds.
I'm just wondering is it normal to have this result in my memory usage:
total used free shared buffers cached
Mem: 6192460 6172488 19972 0 39904 5890824
-/+ buffers/cache: 241760 5950700
Swap: 2096472 0 2096472
What does this mean?
I choose Polesoft Lockspam to fight spam, and you?
http://www.polesoft.com/refer.html
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: cpc@cybees.com
Subject: Re: Configuration Suggestion
In-Reply-To: <000601c5d9f3$5478f260$1e21100a@ghwk02002147>
* 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