Postgres Pro
Downloads
Home   >   mailing lists

Re: Use fadvise in wal replay - Mailing list pgsql-hackers

From Andrey Borodin
Subject Re: Use fadvise in wal replay
Date
Msg-id 1809789D-F3A2-423B-B9B6-3BB34C567594@yandex-team.ru
Whole thread Raw
In response to RE: Use fadvise in wal replay  (Jakub Wartak <Jakub.Wartak@tomtom.com>)
Responses RE: Use fadvise in wal replay
List pgsql-hackers
Tree view 

> On 21 Jun 2022, at 13:20, Jakub Wartak <Jakub.Wartak@tomtom.com> wrote:
>
> Maybe the important question is why would be readahead mechanism be disabled in the first place via /sys | blockdev ?

Because database should know better than OS which data needs to be prefetched and which should not. Big OS readahead
affectsindex scan performance. 

Best regards, Andrey Borodin.

pgsql-hackers by date:

Previous
From: Jakub Wartak
Date:
Subject: RE: Use fadvise in wal replay
Next
From: Jakub Wartak
Date:
Subject: RE: Use fadvise in wal replay