Need for speed - Mailing list pgsql-performance

From Ulrich Wisser
Subject Need for speed
Date
Msg-id 430208AE.7080100@relevanttraffic.se
Whole thread Raw
Responses Re: Need for speed
Re: Need for speed
Re: Need for speed
Re: Need for speed
Re: Need for speed
List pgsql-performance
Hello,

one of our services is click counting for on line advertising. We do
this by importing Apache log files every five minutes. This results in a
lot of insert and delete statements. At the same time our customers
shall be able to do on line reporting.

We have a box with
Linux Fedora Core 3, Postgres 7.4.2
Intel(R) Pentium(R) 4 CPU 2.40GHz
2 scsi 76GB disks (15.000RPM, 2ms)

I did put pg_xlog on another file system on other discs.

Still when several users are on line the reporting gets very slow.
Queries can take more then 2 min.

I need some ideas how to improve performance in some orders of
magnitude. I already thought of a box with the whole database on a ram
disc. So really any idea is welcome.

Ulrich



--
Ulrich Wisser  / System Developer

RELEVANT TRAFFIC SWEDEN AB, Riddarg 17A, SE-114 57 Sthlm, Sweden
Direct (+46)86789755 || Cell (+46)704467893 || Fax (+46)86789769
________________________________________________________________
http://www.relevanttraffic.com

pgsql-performance by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: Looking for a large database for testing
Next
From: bsimon@loxane.com
Date:
Subject: Re. : Need for speed