Performance-Tuning - Mailing list pgsql-general

From Konstantinos Agouros
Subject Performance-Tuning
Date
Msg-id 20010119181104.B15450@rumba.agouros.de
Whole thread Raw
Responses Re: Performance-Tuning  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-general
Hi,

I have a table with the fields data(timestamp), region and url (varchar)
This table has 4.5mio entries a day. To reduce them I use the following
insert-statement.

insert into msreduce select distinct on (region, url) '1-16-2001',region,url,count(client) from microsoftlog where date
>'1-16-2001' and date < '1-17-2001' group by region,url 

My question: Could this be optimized?

Konstantin
--
Konstantin Agouros - NetAge Solutions, Dingolfinger Str. 6, 81673 Muenchen
Tel.: 089 666584-0, Fax: 089 666584-11, Email: Konstantin.Agouros@netage.de
--------------------------------------------------------------------------
Black holes are, where god divided by zero.

----- End forwarded message -----

--
Dipl-Inf. Konstantin Agouros aka Elwood Blues. Internet: elwood@agouros.de
Otkerstr. 28, 81547 Muenchen, Germany. Tel +49 89 69370185
----------------------------------------------------------------------------
"Captain, this ship will not sustain the forming of the cosmos." B'Elana Torres

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: MD5 hash function for PostgreSQL
Next
From: Stephan Szabo
Date:
Subject: Re: child table doesn't inherit PRIMARY KEY?