---------- Forwarded message ----------
From: Kjell Tore Fossbakk <kjelltore@gmail.com>
Date: Jul 26, 2006 8:55 AM
Subject: Performance with 2 AMD/Opteron 2.6Ghz and 8gig DDR PC3200
To: pgsql-performance-owner@postgresql.org

Hello!

I have upgraded my server to an HP Proliant DL585. It got two Processor
motherboards, each holding an AMD/Opteron 2.6Ghz and 4GIG of memory.

I got 4 150GIG SCSI disks in a Smart Array 5i 1+0 RAID.

I'v been using Postgres for a few years, and the reason for this major
hardware upgrade is to boost my performance. I have created a small web
application that pulls huge amounts of data from my database.

The database consists of basically one table, but it's big. It got 10
columns and a few indexes on the 3-4 most used fields (based on my queries
of course). My queries use a few aggregated functions, such as sum and
count, which makes the data moving process time-consuming.

Now, on my older server (2gig memory and probabably some 2ghz cpu) my
queries took quite a lot of time (30sec - several minutes). Now, with a much
better hardware platform, I was hoping I could juice the process!

As I have understood, there is alot of tuning using both postgres.conf and
analyzing queries to make the values of postgres.conf fit my needs, system
and hardware. This is where I need some help. I have looked into
postgres.conf , and seen the tunings. But I'm still not sure what I should
put into those variables (in postgres.conf) with my hardware.

Any suggestions would be most appreciated!

- Kjell Tore

--
"Be nice to people on your way up because you meet them on your way down."


--
"Be nice to people on your way up because you meet them on your way down."

Hello.

OS: Gentoo 2006.0 with gentoo's hardened kernel
Version: I haven't checked. Im guessing 8.0.8 (latest stable on all systems)
or 8.1.4 which is the latest package.

I'm still gonna try to run with smart array 5i. How can i find out that my
performance with that is crappy? Without ripping down my systems, and using
software raid?

Kjell Tore

On 7/28/06, Claus Guttesen <kometen@gmail.com> wrote:
>
> > As I have understood, there is alot of tuning using both postgres.confand
> > analyzing queries to make the values of postgres.conf fit my needs,
> system
> > and hardware. This is where I need some help. I have looked into
> > postgres.conf , and seen the tunings. But I'm still not sure what I
> should
> > put into those variables (in postgres.conf) with my hardware.
> >
> > Any suggestions would be most appreciated!
>
> What OS is it running and what version is postgresql?
>
> regards
> Claus
>



--
"Be nice to people on your way up because you meet them on your way down."