Re: Really really slow select count(*)

Поиск
Список
Период
Сортировка
От felix
Тема Re: Really really slow select count(*)
Дата
Msg-id AANLkTimONxqmK=Tf_qooO5=PKEEDMptZ6=rZ7ASmziX+@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Really really slow select count(*)  ("Pierre C" <lists@peufeu.com>)
Список pgsql-performance

yeah, it already uses memcached with db save.  nothing important in session anyway

the session table is not the issue

and I never clustered that one or ever will

thanks for the tip, also the other one about HOT


On Sun, Feb 6, 2011 at 8:19 PM, Pierre C <lists@peufeu.com> wrote:

I have clustered that table, its still unbelievably slow.

Did you actually delete the old entries before clustering it?  if it's
still got 4G of old sessions or whatever in it, clustering ain't gonna
help.

Also, IMHO it is a lot better to store sessions in something like memcached, rather than imposing this rather large load on the main database...

PS : if your site has been down for 6 hours, you can TRUNCATE your sessions table...

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

Предыдущее
От: felix
Дата:
Сообщение: Re: Really really slow select count(*)
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: Really really slow select count(*)