Re: Very big insert/join performance problem (bacula)

Поиск
Список
Период
Сортировка
От Marc Cousin
Тема Re: Very big insert/join performance problem (bacula)
Дата
Msg-id 200907240713.06926.cousinmarc@gmail.com
обсуждение исходный текст
Ответ на Re: Very big insert/join performance problem (bacula)  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: Very big insert/join performance problem (bacula)  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-performance
> It really has very little impact.  It only affects index scans, and
> even then only if effective_cache_size is less than the size of the
> table.
>
> Essentially, when this kicks in, it models the effect that if you are
> index scanning a table much larger than the size of your cache, you
> might have to reread some blocks that you previously read in during
> *that same index scan*.


Ok, thanks for clearing that up for me. Still, I think the doc could be
improved on this point (sorry to be a bit obsessed with that, but I'm one of
the french translators, so I like the doc to be perfect :) )

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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Very big insert/join performance problem (bacula)
Следующее
От: "Albe Laurenz"
Дата:
Сообщение: Re: Configuring Postgresql for writing BLOB at a high-rate