| 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: | 430208AE.7080100@relevanttraffic.se |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | bsimon | 2005-08-16 16:02:53 | Re. : Need for speed |
| Previous Message | Oleg Bartunov | 2005-08-16 09:38:41 | Re: Looking for a large database for testing |