Re: Suppressing useless wakeups in walreceiver - Mailing list pgsql-hackers

From Nathan Bossart
Subject Re: Suppressing useless wakeups in walreceiver
Date
Msg-id 20221113222644.GA1269110@nathanxps13
Whole thread Raw
In response to Re: Suppressing useless wakeups in walreceiver  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Suppressing useless wakeups in walreceiver
List pgsql-hackers
On Sun, Nov 13, 2022 at 05:08:04PM -0500, Tom Lane wrote:
> There is something very seriously wrong with this patch.
> 
> On my machine, running "make -j10 check-world" (with compilation
> already done) has been taking right about 2 minutes for some time.
> Since this patch, it's taking around 2:45 --- I did a bisect run
> to confirm that this patch is where it changed.

I've been looking into this.  I wrote a similar patch for logical/worker.c
before noticing that check-world was taking much longer.  The problem in
that case seems to be that process_syncing_tables() isn't called as often.
It wouldn't surprise me if there's also something in walreceiver.c that
depends upon the frequent wakeups.  I suspect this will require a revert.

-- 
Nathan Bossart
Amazon Web Services: https://aws.amazon.com



pgsql-hackers by date:

Previous
From: Thomas Munro
Date:
Subject: Re: Suppressing useless wakeups in walreceiver
Next
From: Simon Riggs
Date:
Subject: Re: Reducing power consumption on idle servers