Re: index prefetching

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: index prefetching
Дата
Msg-id rybxcmbauhmbvqugsddozowhgeu3ksakwjswwz55wdcovfuzrv@5kupnuviicyn
обсуждение исходный текст
Ответ на Re: index prefetching  (Tomas Vondra <tomas@vondra.me>)
Ответы Re: index prefetching
Re: index prefetching
Список pgsql-hackers
Hi,

On 2025-07-23 02:50:04 +0200, Tomas Vondra wrote:
> But I don't see why would this have any effect on the prefetch distance,
> queue depth etc. Or why decreasing INDEX_SCAN_MAX_BATCHES should improve
> that. I'd have expected exactly the opposite behavior.
> 
> Could be bug, of course. But it'd be helpful to see the dataset/query.

Pgbench scale 500, with the simpler query from my message.

Greetings,

Andres Freund



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