Message-ID: <1e28a879-907d-4bf1-a2c8-b89128cfc78f@abcsql.com>
Date: Sat, 30 Dec 2023 13:01:04 +0100
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Streaming I/O, vectored I/O (WIP)
Content-Language: fr, en-US
To: Thomas Munro <thomas.munro@gmail.com>,
 Heikki Linnakangas <hlinnaka@iki.fi>
Cc: Andres Freund <andres@anarazel.de>,
 pgsql-hackers <pgsql-hackers@postgresql.org>,
 Melanie Plageman <melanieplageman@gmail.com>
References: 
 <CA+hUKGJkOiOCa+mag4BF+zHo7qo=o9CFheB8=g6uT5TUm2gkvA@mail.gmail.com>
 <b336fbe8-1ad0-c289-5ed8-bbb74513e5bb@iki.fi>
 <CA+hUKGKOc4=TTNv_r4F03QafvK7qo7itN+OwUdMX5UMjYiqybA@mail.gmail.com>
 <1c6f0c38-9181-4869-983f-3d6ef17dea3c@iki.fi>
 <CA+hUKGJywvC5J+rcLs3+whK8YPBnKXVLn5o0JFJbNeb4CEdSFA@mail.gmail.com>
 <f748992c-26f1-4389-9349-06a0ab75046c@iki.fi>
 <CA+hUKG+ZLXp1jk+ML11GedOUKw9mEzAie3nmY9041CygNpd=9w@mail.gmail.com>
 <20231208182554.swereaxcgvq72ts6@awork3.anarazel.de>
 <CA+hUKGJLW3pwf7yWWCkoLD+kGb_J3B+Q-oa9ufq82_HAsW0QxA@mail.gmail.com>
 <4533e76e-9519-4715-acd0-d4fa552619b0@iki.fi>
 <CA+hUKGK1GwoxONGftaP8M0git=Mo15oKytasY+ChV-2hF+726Q@mail.gmail.com>
From: =?UTF-8?Q?C=C3=A9dric_Villemain?= <cedric.villemain+pgsql@abcsql.com>
Organization: Data Bene
In-Reply-To: 
 <CA+hUKGK1GwoxONGftaP8M0git=Mo15oKytasY+ChV-2hF+726Q@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: 
 <https://www.postgresql.org/message-id/1e28a879-907d-4bf1-a2c8-b89128cfc78f%40abcsql.com>
Precedence: bulk

Le 11/12/2023 à 10:12, Thomas Munro a écrit :
> 3.  smgrreadv/smgrwritev patch:
> 
>   * improved ENOSPC handling
>   * improve description of EOF and ENOSPC handling
>   * fixed the sizes reported in dtrace static probes
>   * fixed some words in the docs about that
>   * changed error messages to refer to "blocks %u..%u"
> 
> 4.  smgrprefetch-with-nblocks patch has no change, hasn't drawn any
> comments hopefully because it is uncontroversial.
> 
> I'm planning to commit these fairly soon.


Thanks, very useful additions.
Not sure what you have already done to come next...

I have 2 smalls patches here:
* to use range prefetch in pg_prewarm (smgrprefetch only at the moment, 
using smgrreadv to come next).
* to support nblocks=0 in smgrprefetch (posix_fadvise supports a len=0 
to apply flag from offset to end of file).

Should I add to commitfest ?
---
Cédric Villemain +33 (0)6 20 30 22 52
https://Data-Bene.io
PostgreSQL Expertise, Support, Training, R&D