Re: Needed: Simplified guide to optimal memory configuration

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: Needed: Simplified guide to optimal memory configuration
Дата
Msg-id 20050615141949.GB7595@wolff.to
обсуждение исходный текст
Ответ на Needed: Simplified guide to optimal memory configuration  (Todd Landfried <tlandfried@viatornetworks.com>)
Список pgsql-performance
On Wed, Jun 15, 2005 at 02:06:27 -0700,
  Todd Landfried <tlandfried@viatornetworks.com> wrote:
>
> What's the problem? The sucker gets s-l-o-w on relatively simple
> queries. For example, simply listing all of the users online at one
> time takes 30-45 seconds if we're talking about 800 users. We've
> adjusted the time period for vacuuming the tables to the point where
> it occurs once an hour, but we're getting only a 25% performance gain
> from that. We're looking at the system settings now to see how those
> can be tweaked.

It might be useful to see example slow queries and the corresponding
explain analyze output.

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Needed: Simplified guide to optimal memory configuration
Следующее
От: Karim Nassar
Дата:
Сообщение: Re: Index ot being used