Re: Configuration Recommendations

От: Kevin Grittner
Тема: Re: Configuration Recommendations
Дата: ,
Msg-id: 4FA3B0940200002500047881@gw.wicourts.gov
(см: обсуждение, исходный текст)
Ответ на: Re: Configuration Recommendations  (Jan Nielsen)
Список: pgsql-performance

Скрыть дерево обсуждения

Configuration Recommendations  (Jan Nielsen, )
 Re: Configuration Recommendations  (Robert Klemme, )
  Re: Configuration Recommendations  ("Greg Sabino Mullane", )
   Re: Configuration Recommendations  (Robert Klemme, )
    Re: Configuration Recommendations  ("Greg Sabino Mullane", )
     Re: Configuration Recommendations  (Robert Klemme, )
     Re: Configuration Recommendations  (Jan Nielsen, )
 Re: Configuration Recommendations  (Shaun Thomas, )
  Re: Configuration Recommendations  (Jan Nielsen, )
  Re: Configuration Recommendations  (John Lister, )
 Re: Configuration Recommendations  (Jan Nielsen, )
 Re: Configuration Recommendations  (Shaun Thomas, )
  Re: Configuration Recommendations  (Jan Nielsen, )
   Re: Configuration Recommendations  (John Lister, )
    Re: Configuration Recommendations  (Jan Nielsen, )
     Re: Configuration Recommendations  (Craig James, )
      Re: Configuration Recommendations  (Scott Carey, )
      Re: Configuration Recommendations  (John Lister, )
   Re: Configuration Recommendations  (Robert Klemme, )
    Re: Configuration Recommendations  (Jan Nielsen, )
    Re: Configuration Recommendations  (Shaun Thomas, )
   Re: Configuration Recommendations  (Jan Nielsen, )
    Re: Configuration Recommendations  ("Kevin Grittner", )
    Re: Configuration Recommendations  (Jeff Janes, )
    Re: Configuration Recommendations  (Jan Nielsen, )
     Re: Configuration Recommendations  (Jan Nielsen, )
     Re: Configuration Recommendations  (Mark Kirkwood, )
  Re: Configuration Recommendations  (Scott Carey, )
 Re: Configuration Recommendations  (Greg Smith, )
 Re: Configuration Recommendations  (Jan Nielsen, )
  Re: Configuration Recommendations  (Shaun Thomas, )

Jan Nielsen <> wrote:

> The range 2048-8192 is an area to study in more detail, obviously.
> Feedback welcome.

I don't see what's to study there, really.  Performance drops off
when database size grows from 30GB to 60GB on a system with 48GB
RAM. And even more when you double database size again.  Access to
disk is slower than access to system RAM.  Is there something else I
should notice that I'm missing?

The local dips in the list suggest that you're not controlling for
checkpoints or autovacuum runs as well as you might, or that you're
not using a large enough number of runs at each scale.

-Kevin


В списке pgsql-performance по дате сообщения:

От: Richard Jones
Дата:
Сообщение: Re: Partitioned/inherited tables with check constraints causing slower query plans
От: Martin Grotzke
Дата:
Сообщение: Re: Several optimization options (config/hardware)