performance in selecting from very large recordset - Mailing list 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