On Mon, 6 Nov 2023 at 22:36, Tomas Vondra wrote:
>
> Seems cfbot was not entirely happy about the patch, for two reasons:
>
> 1) enable_insert_prefetching definition was inconsistent (different
> boot/default values, missing in .conf and so on)
>
> 2) stupid bug in execReplication, inserting index
On 11/23/23 14:26, Heikki Linnakangas wrote:
> On 06/11/2023 19:05, Tomas Vondra wrote:
>> As for the path forward, I think the prefetching is demonstrably
>> beneficial. There are cases where it can't help or even harms
>> performance. I think the success depends on three areas:
>>
>> (a) reduc
On 06/11/2023 19:05, Tomas Vondra wrote:
As for the path forward, I think the prefetching is demonstrably
beneficial. There are cases where it can't help or even harms
performance. I think the success depends on three areas:
(a) reducing the costs of the prefetching - For example right now we
bu
Seems cfbot was not entirely happy about the patch, for two reasons:
1) enable_insert_prefetching definition was inconsistent (different
boot/default values, missing in .conf and so on)
2) stupid bug in execReplication, inserting index entries twice
The attached v3 should fix all of that, I beli
Hi,
Some time ago I started a thread about prefetching heap pages during
index scans [1]. That however only helps when reading rows, not when
inserting them.
Imagine inserting a row into a table with many indexes - we insert the
row into the table, and then into the indexes one by one, synchronou
