Re: [Lsf-pc] Linux kernel impact on PostgreSQL performance

Поиск
Список
Период
Сортировка
От Jan Kara
Тема Re: [Lsf-pc] Linux kernel impact on PostgreSQL performance
Дата
Msg-id 20140113223844.GB10366@quack.suse.cz
обсуждение исходный текст
Ответ на Re: Linux kernel impact on PostgreSQL performance  (Mel Gorman <mgorman@suse.de>)
Список pgsql-hackers
On Mon 13-01-14 22:26:45, Mel Gorman wrote:
> The flipside is also meant to hold true. If you know data will be needed
> in the near future then posix_fadvise(POSIX_FADV_WILLNEED). Glancing at
> the implementation it does a forced read-ahead on the range of pages of
> interest. It doesn't look like it would block. That's not quite true. POSIX_FADV_WILLNEED still needs to map logical
file offsets to physical disk blocks and create IO requests. This happens
synchronously. So if your disk is congested and relevant metadata is out of
cache, or we simply run out of free IO requests, POSIX_FADV_WILLNEED can
block for a significant amount of time.
                            Honza
-- 
Jan Kara <jack@suse.cz>
SUSE Labs, CR



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

Предыдущее
От: Trond Myklebust
Дата:
Сообщение: Re: [Lsf-pc] Linux kernel impact on PostgreSQL performance
Следующее
От: Theodore Ts'o
Дата:
Сообщение: Re: [Lsf-pc] Linux kernel impact on PostgreSQL performance