Re: patch: improve SLRU replacement algorithm

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: patch: improve SLRU replacement algorithm
Дата
Msg-id CAM-w4HNMf-tAZRVuVwgmrxRqLXJFJ47f-XkFh+QLxwSpTbM=CA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: patch: improve SLRU replacement algorithm  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
On Wed, Apr 4, 2012 at 9:05 PM, Robert Haas <robertmhaas@gmail.com> wrote:
> Here's a sample of how often that's firing, by second, on
> this test (pgbench with 32 clients):
>
>   4191 19:54:21
>   4540 19:54:22

Hm, so if that's evenly spread out that's 1/4ms between slru flushes
and if each flush takes 5-10ms that's going to be 20-40 flushes
concurrently going on.

I'm curious to see a distribution of how many flushes are already
concurrently happening whenever a flush is initiated. This should be
possible to get by counting the number of pages that were skipped in
your patch as it went through the slru.

Also, oops, sorry. I mixed up the 32 clog buffers with the 16 files
that the slru.c remembers during a flush to fsync later. I still don't
understand why it doesn't just allocate enough space to remember to
fsync the worst case which is one file per clog buffer though which
would only be twice as many.

--
greg


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

Предыдущее
От: Greg Stark
Дата:
Сообщение: Re: patch: improve SLRU replacement algorithm
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Speed dblink using alternate libpq tuple storage