Date: Mon, 22 Aug 2005 19:48:56 -0500
From: "Jim C. Nasby" <jnasby@pervasive.com>
To: Alex Turner <armtuk@gmail.com>
Cc: Ulrich Wisser <ulrich.wisser@relevanttraffic.se>,
	pgsql-performance@postgresql.org
Subject: Re: Need for speed
Message-ID: <20050823004856.GH17203@pervasive.com>
References: <430208AE.7080100@relevanttraffic.se>
	<33c6269f050816105957ae5d6f@mail.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <33c6269f050816105957ae5d6f@mail.gmail.com>
User-Agent: Mutt/1.5.9i

RRS (http://rrs.decibel.org) might be of use in this case.

On Tue, Aug 16, 2005 at 01:59:53PM -0400, Alex Turner wrote:
> Are you calculating aggregates, and if so, how are you doing it (I ask
> the question from experience of a similar application where I found
> that my aggregating PGPLSQL triggers were bogging the system down, and
> changed them so scheduled jobs instead).
> 
> Alex Turner
> NetEconomist
> 
> On 8/16/05, Ulrich Wisser <ulrich.wisser@relevanttraffic.se> 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.
> > 
> > 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
> > 
> > ---------------------------(end of broadcast)---------------------------
> > TIP 1: if posting/reading through Usenet, please send an appropriate
> >        subscribe-nomail command to majordomo@postgresql.org so that your
> >        message can get through to the mailing list cleanly
> >
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
> 

-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software        http://pervasive.com        512-569-9461