Обсуждение: Inquiry From Form [pgsql]

Поиск
Список
Период
Сортировка

Inquiry From Form [pgsql]

От
Christian Schneidewind
Дата:
Hallo,

We are using Postgres 7.3 on Red Hat 7.2 Linux.
We use Inheritance with tables.
All our queries on tables, having child-tables, take a awfull big amount of time. We put indexes on parent- and
child-tables,but the performance 
stays at a very low level when I ask on parent-tables.

Even a very simple query like :

select count(id) from iobjekt or
select id from iobjekt

Id is th primary key, I use.

Can you me give an advice to what detail, I should have a look on.

Thank you.

with best regards

Christian Schneidewind