performance in selecting from very large recordset

From: "Hijax" <hijax_pl(at)wp(dot)pl>
To: pgsql-general(at)postgresql(dot)org
Subject: performance in selecting from very large recordset
Date: 2003-12-18 13:33:50
Message-ID: brsabv$gi$1@news2.ipartners.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

What about posgtesql performace in selecting from million of records?

I have a database with about 23 miilion of touples in single table. Data
represents a analog signal values from multiples sources... These values are
gathered in every minute...

How to create a select statement.... or how to create indexes... for maximum
performance...

Any guidelines?

Arek

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2003-12-18 13:39:44 Re: pqReadData() -- read() failed: errno=32
Previous Message D. Dante Lorenso 2003-12-18 13:17:47 How to navigate tree without CONNECT BY?