Re: PostgreSQL on ZFS: performance tuning

Поиск
Список
Период
Сортировка
От trafdev
Тема Re: PostgreSQL on ZFS: performance tuning
Дата
Msg-id 70bfa668-8904-8668-d0a6-6a6e27d38245@mail.ru
обсуждение исходный текст
Ответ на Re: PostgreSQL on ZFS: performance tuning  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Список pgsql-performance
> > - from what I can see, Postgres uses memory too carefully. I would like
> > somehow to force it to keep accessed data in memory as long as possible.
> > Instead I often see that even frequently accessed data is pushed out of
> > memory cache for no apparent reasons.
> >
>
> This is probably a consequence of the primarycache misconfiguration.

Thanks! And I'm using "primarycache=all" in my deployment...


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

Предыдущее
От: Tomas Vondra
Дата:
Сообщение: Re: PostgreSQL on ZFS: performance tuning
Следующее
От: Andreas Joseph Krogh
Дата:
Сообщение: Very poor performance with Nested Loop Anti Join