Skip site navigation (1) Skip section navigation (2)

Slow performance...

From: wim <wdh(at)belbone(dot)be>
To: pgsql-novice(at)postgresql(dot)org
Subject: Slow performance...
Date: 2002-03-11 11:12:27
Message-ID: 3C8C911B.9040809@belbone.be (view raw or flat)
Thread:
Lists: pgsql-novice
Hey all,

I encounter a major problem: I've running Postgres 7.1 on a Sun 220R 
(with only one processor). Postgres has a database with a table with 
more than 300000 rows. The lay-out of my table is:

timestamp | interface | datain | dataout

I created indexes on the first two fields (timestamp and interface).


I've written a perl script that fetches data from the DB.
I do it the following way:

SELECT SUM(datain), SUM(dataout) FROM traffic_counters WHERE timestamp 
LIKE '$yr-$mon-$day $hour:$minute%' AND interface LIKE '%$billingtable%'";

Now the problem is that it takes about ten seconds to get only a single 
result... There are 24 hours in one day, so you can see that my script 
runs for quite a time...

Is there a way to speed up thing (a lot)?

Thanx guys!


-- 
Kind regards,

Wim De Hul
Belgacom Belbone
--------------------------------
  Mail   : wdh(at)belbone(dot)be
  Mobile : +32 479 952004
  Ripe   : WDH25-RIPE
  Registered Linux User: #260015
--------------------------------


Responses

pgsql-novice by date

Next:From: Nicolas BoretosDate: 2002-03-11 11:14:43
Subject: Sparc/Solaris2.6 Postgresql 7.1.3 Binary?
Previous:From: Thorsten HaudeDate: 2002-03-10 20:04:45
Subject: Re: create database, user

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group