From: Richard Huxton <dev@archonet.com>
To: Ulrich Wisser <ulrich.wisser@relevanttraffic.se>
Cc: pgsql-performance@postgresql.org
Subject: Re: Need for speed
Date: Tue, 16 Aug 2005 17:03:55 +0100
Message-ID: <43020E6B.9080607@archonet.com> (raw)
In-Reply-To: <430208AE.7080100@relevanttraffic.se>
References: <430208AE.7080100@relevanttraffic.se>
Ulrich Wisser wrote:
> 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.
> 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.
So what's the problem - poor query plans? CPU saturated? I/O saturated?
Too much context-switching?
What makes it worse - adding another reporting user, or importing
another logfile?
--
Richard Huxton
Archonet Ltd
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: dev@archonet.com, ulrich.wisser@relevanttraffic.se
Subject: Re: Need for speed
In-Reply-To: <43020E6B.9080607@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox