Re: 回复:Re: 回复:Re: speed up pg_upgrade with large number of tables - Mailing list pgsql-hackers

From Nathan Bossart
Subject Re: 回复:Re: 回复:Re: speed up pg_upgrade with large number of tables
Date
Msg-id Z5FZ8BKxTNH9bxKM@nathan
Whole thread Raw
In response to Re: 回复:Re: 回复:Re: speed up pg_upgrade with large number of tables  (Hari Krishna Sunder <hari.db.pg@gmail.com>)
List pgsql-hackers
On Sun, Jan 19, 2025 at 03:57:18PM -0800, Hari Krishna Sunder wrote:
> The restore side speedups suggested by Yang seem reasonable and can
> potentially speed up the process. We can even go a bit further by starting
> the new postgres in a --binary-upgrade mode and skip some of these locks
> completely.

I am curious about what kind of speedup we can expect with these patches.
IMHO some benchmarking results would be useful.

-- 
nathan



pgsql-hackers by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: Proposal: "query_work_mem" GUC, to distribute working memory to the query's individual operators
Next
From: Tomas Vondra
Date:
Subject: Re: Proposal: "query_work_mem" GUC, to distribute working memory to the query's individual operators