Thread: pgsql: pg_upgrade: Parallelize retrieving relation information.

pgsql: pg_upgrade: Parallelize retrieving relation information.

From
Nathan Bossart
Date:
pg_upgrade: Parallelize retrieving relation information.

This commit makes use of the new task framework in pg_upgrade to
parallelize retrieving relation and logical slot information.  This
step will now process multiple databases concurrently when
pg_upgrade's --jobs option is provided a value greater than 1.

Reviewed-by: Daniel Gustafsson, Ilya Gladyshev
Discussion: https://postgr.es/m/20240516211638.GA1688936%40nathanxps13

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/6d3d2e8e541f07dafb6a42a105b3ca78b2a09437

Modified Files
--------------
src/bin/pg_upgrade/info.c | 296 ++++++++++++++++++++++++----------------------
1 file changed, 154 insertions(+), 142 deletions(-)


Re: pgsql: pg_upgrade: Parallelize retrieving relation information.

From
Alexander Korotkov
Date:
On Tue, Sep 17, 2024 at 12:11 AM Nathan Bossart <nathan@postgresql.org> wrote:
> pg_upgrade: Parallelize retrieving relation information.
>
> This commit makes use of the new task framework in pg_upgrade to
> parallelize retrieving relation and logical slot information.  This
> step will now process multiple databases concurrently when
> pg_upgrade's --jobs option is provided a value greater than 1.
>
> Reviewed-by: Daniel Gustafsson, Ilya Gladyshev
> Discussion: https://postgr.es/m/20240516211638.GA1688936%40nathanxps13

 #include "access/transam.h"
 #include "catalog/pg_class_d.h"
+#include "pqexpbuffer.h"
 #include "pg_upgrade.h"

I think the alphabetic order of includes needs fixing.

------
Regards,
Alexander Korotkov
Supabase