On Fri, Apr 9, 2010 at 10:27 AM, renier <renier(at)vvconsult(dot)co(dot)za> wrote:
> Hi There. Is there anyone in the SA PostgreSQL community that is willing
> to assist us.
> We started trials on PostgreSQL just over a year ago, so we used on old
> desktop lying around as our database server, which served fine for testing
> purposes. We eventually bought a new server (2x2.93GHZ Quad core Xeon, 32GB
> RAM, 6x450GB SAS 15000RPM drives etc), quite a decent machine, but the
> performance on this machine is the same, if not worse, than it is on our old
> “server”. We tried tweaking the postgres.conf file but we do not really
> have enough knowledge of this file and performance does not increase, or the
> service wont start.
> Is there anyone out there with enough experience in postgreSQL tweaking
> that might be willing to assist in some db tuning, and help us learn?
Hi Renier, you'll have to be bit more specific regarding the setup there?
1) What version of postgres?
2) What type of application will be using it? Website/intranet site/custom
3) How many connections are we talking here?
4) Maybe post your current config files to the web somewhere, where people
can have a look?
More information you can give, the easier people can help you guys?
In response to
jnbpug by date
|Next:||From: Alastair Turner||Date: 2010-04-09 10:09:02|
|Subject: Re: PostgreSQL Tweaking|
|Previous:||From: renier||Date: 2010-04-09 08:27:18|
|Subject: PostgreSQL Tweaking|