select count(*) performance

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

I'm new in PostgreSQL Business, therefore please forgive me a "newbie"
Question. I have a table with ca. 1.250.000 Records. When I execute
a "select count (*) from table" (with pgAdmin III)  it takes about 40
secs.
I think that takes much to long. Can you please give me hints, where
I can search for Improvements?

TIA, Det


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

Предыдущее
От: "slawekj"
Дата:
Сообщение: Re: select count(*) performance
Следующее
От: Piotr Kołaczkowski
Дата:
Сообщение: Re: Update table performance