performance in selecting from very large recordset

Поиск
Список
Период
Сортировка
От Hijax
Тема performance in selecting from very large recordset
Дата
Msg-id brsabv$gi$1@news2.ipartners.pl
обсуждение исходный текст
Список 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



В списке pgsql-general по дате отправления:

Предыдущее
От: "Mark Twombley"
Дата:
Сообщение: Has anyone seen an ADO Provider for Postresql?
Следующее
От: venkat j
Дата:
Сообщение: dblink_connect fails