Skip site navigation (1) Skip section navigation (2)

Need for speed

From: Ulrich Wisser <ulrich(dot)wisser(at)relevanttraffic(dot)se>
To: pgsql-performance(at)postgresql(dot)org
Subject: Need for speed
Date: 2005-08-16 15:39:26
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance

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 Wisser  / System Developer

RELEVANT TRAFFIC SWEDEN AB, Riddarg 17A, SE-114 57 Sthlm, Sweden
Direct (+46)86789755 || Cell (+46)704467893 || Fax (+46)86789769


pgsql-performance by date

Next:From: bsimonDate: 2005-08-16 16:02:53
Subject: Re. : Need for speed
Previous:From: Oleg BartunovDate: 2005-08-16 09:38:41
Subject: Re: Looking for a large database for testing

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group