From: Ulrich Wisser <ulrich.wisser@relevanttraffic.se>
To: Merlin Moncure <merlin.moncure@rcsonline.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Need for speed 3
Date: Thu, 01 Sep 2005 16:06:18 +0200
Message-ID: <43170ADA.2080002@relevanttraffic.se> (raw)
In-Reply-To: <6EE64EF3AB31D5448D0007DD34EEB3417DD24C@Herge.rcsinc.local>
References: <6EE64EF3AB31D5448D0007DD34EEB3417DD24C@Herge.rcsinc.local>
Hi Merlin,
> schemas would be helpful.
right now I would like to know if my approach to the problem makes
sense. Or if I should rework the whole procedure of import and aggregate.
> Just a thought: have you considered having apache logs write to a
> process that immediately makes insert query(s) to postgresql?
Yes we have considered that, but dismissed the idea very soon. We need
Apache to be as responsive as possible. It's a two server setup with
load balancer and failover. Serving about ones thousand domains and
counting. It needs to be as failsafe as possible and under no
circumstances can any request be lost. (The click counting is core
business and relates directly to our income.)
That said it seemed quite save to let Apache write logfiles. And import
them later. By that a database downtime wouldn't be mission critical.
> You could write small C program which executes advanced query interface
> call to the server.
How would that improve performance?
Ulrich
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: ulrich.wisser@relevanttraffic.se, merlin.moncure@rcsonline.com
Subject: Re: Need for speed 3
In-Reply-To: <43170ADA.2080002@relevanttraffic.se>
* 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