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
Дата	25 марта 2008 г. 05:50:35
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
Список	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 по дате отправления:

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

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