Postgres Pro
Downloads
Home   >   mailing lists

Re: Prefetch the next tuple's memory during seqscans - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Prefetch the next tuple's memory during seqscans
Date
Msg-id 20221102205347.3mtpvhl4a63nn7dv@awork3.anarazel.de
Whole thread Raw
In response to Re: Prefetch the next tuple's memory during seqscans  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers
Tree view 
Hi,

On 2022-11-02 10:25:44 -0700, Andres Freund wrote:
> server is started with
> local: numactl --membind 1 --physcpubind 10
> remote: numactl --membind 0 --physcpubind 10
> interleave: numactl --interleave=all --physcpubind 10

Argh, forgot to say that this is with max_parallel_workers_per_gather=0,
s_b=8GB, huge_pages=on.

Greetings,

Andres Freund

pgsql-hackers by date:

Previous
From: Daniel Gustafsson
Date:
Subject: Re: pg_basebackup's --gzip switch misbehaves
Next
From: Peter Smith
Date:
Subject: Re: create subscription - improved warning message