From: | Konstantinos Agouros <elwood(at)agouros(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Performance-Tuning |
Date: | 2001-01-19 17:11:04 |
Message-ID: | 20010119181104.B15450@rumba.agouros.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(dot)Agouros(at)netage(dot)de
--------------------------------------------------------------------------
Black holes are, where god divided by zero.
----- End forwarded message -----
--
Dipl-Inf. Konstantin Agouros aka Elwood Blues. Internet: elwood(at)agouros(dot)de
Otkerstr. 28, 81547 Muenchen, Germany. Tel +49 89 69370185
----------------------------------------------------------------------------
"Captain, this ship will not sustain the forming of the cosmos." B'Elana Torres
From | Date | Subject | |
---|---|---|---|
Next Message | Nathan Heagy | 2001-01-19 17:11:33 | Re: Selects with Array member |
Previous Message | Alex Pilosov | 2001-01-19 17:00:30 | Re: Questions about Synonyms - Again |