Re: postgresql is slow with larger table even it is in RAM

Поиск
Список
Период
Сортировка
От sathiya psql
Тема Re: postgresql is slow with larger table even it is in RAM
Дата
Msg-id f966c2ee0803250150p3b3cf68bn32fd044ecf783624@mail.gmail.com
обсуждение исходный текст
Ответ на Re: postgresql is slow with larger table even it is in RAM  ("Uwe C. Schroeder" <uwe@oss4u.com>)
Ответы Re: postgresql is slow with larger table even it is in RAM  ("sathiya psql" <sathiya.psql@gmail.com>)
Список pgsql-admin
Дерево обсуждения
I can't really say anything about your RAM issue, but count(*) is always a bad
idea if it can be avoided. Assuming you have a primary key on the table, do a
count(pk). In my experience that alone cuts down up to 30% of execution time.

i want exact count so am doing this...

But as you are saying it is not doing so,
at first without primary key i had a column "id", it took the same 3 seconds to show the count, after reading some tips i created primary key on that "id", and i did select count(id) from table, and now also it is taking the same 3 seconds.

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

Предыдущее
От: "sathiya psql"
Дата:
Сообщение: Re: postgresql is slow with larger table even it is in RAM
Следующее
От: "sathiya psql"
Дата:
Сообщение: Re: postgresql is slow with larger table even it is in RAM