Re: Expanding HOT updates for expression and partial indexes

> On Feb 10, 2025, at 12:17 PM, Matthias van de Meent > wrote: > >> >> I have a few concerns with the patch, things I’d greatly appreciate your >> thoughts on: >> >> First, I pass an EState along the update path to enable running the checks >> in heapam, this works but leaves me feeling as

Re: AIO v2.3

Hi, On 2025-02-11 11:48:38 +1300, Thomas Munro wrote: > On Thu, Jan 23, 2025 at 5:29 PM Andres Freund wrote: > > - Heikki doesn't love pgaio_submit_staged(), suggested pgaio_kick_staged() > > or > > such. I don't love that name though. > > Problem statement: You want to be able to batch I/O su

Re: RFC: Allow EXPLAIN to Output Page Fault Information

On Mon, 10 Feb 2025 at 14:31, Andres Freund wrote: > I think it'll always be a subset of use. It doesn't make sense to use DIO for > a small databases or untuned databases. Or a system that's deliberately > overcommmitted. Thanks, that's useful context. > But this will also not work with AIO w/

Re: Eagerly scan all-visible pages to amortize aggressive vacuum

Hi, On 2025-02-04 12:44:22 -0500, Melanie Plageman wrote: > On Mon, Feb 3, 2025 at 9:09 PM Andres Freund wrote: > > > + /* > > > + * Now calculate the eager scan start block. Start at a random spot > > > + * somewhere within the first eager scan region. This avoids eager > > > +

Re: [RFC] Lock-free XLog Reservation from WAL

On Mon, 10 Feb 2025 at 22:12, "Zhou, Zhiguo" wrote: > On 2/5/2025 4:32 PM, Japin Li wrote: >> On Mon, 27 Jan 2025 at 17:30, "Zhou, Zhiguo" wrote: >>> On 1/26/2025 10:59 PM, Yura Sokolov wrote: 24.01.2025 12:07, Japin Li пишет: > On Thu, 23 Jan 2025 at 21:44, Japin Li wrote: >> On Th

<    1   2