Message-ID: <42C2D7B5.4070707@wildcash.com>
Date: Wed, 29 Jun 2005 10:17:41 -0700
From: Rudi Starcevic <tech@wildcash.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
	rv:1.7) Gecko/20040616
MIME-Version: 1.0
To: Postgresql Performance list <pgsql-performance@postgresql.org>
Subject: Re: optimized counting of web statistics
References: <6EE64EF3AB31D5448D0007DD34EEB3415C2C08@Herge.rcsinc.local>	
	<22455e7050628133978b17cd4@mail.gmail.com>
	<f3c0b408050628145545699c4e@mail.gmail.com>
In-Reply-To: <f3c0b408050628145545699c4e@mail.gmail.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hi,

>I do my batch processing daily using a python script I've written. I
>found that trying to do it with pl/pgsql took more than 24 hours to
>process 24 hours worth of logs. I then used C# and in memory hash
>tables to drop the time to 2 hours, but I couldn't get mono installed
>on some of my older servers. Python proved the fastest and I can
>process 24 hours worth of logs in about 15 minutes. Common reports run
>in < 1 sec and custom reports run in < 15 seconds (usually).
>  
>

When you say you do your batch processing in a Python script do you mean
a you are using 'plpython' inside
PostgreSQL or using Python to execut select statements and crunch the
data 'outside' PostgreSQL?

Your reply is very interesting.

Thanks.
Regards,
Rudi.