pg.ddx.io  pgsql-committers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
pgsql: pg_upgrade: Parallelize retrieving loadable libraries.
4+ messages / 2 participants
[nested] [flat]

* pgsql: pg_upgrade: Parallelize retrieving relation information.
@ 2024-09-16 21:11 Nathan Bossart <nathan@postgresql.org>
  2024-09-17 19:59 ` Re: pgsql: pg_upgrade: Parallelize retrieving relation information. Alexander Korotkov <aekorotkov@gmail.com>
  0 siblings, 1 reply; 4+ messages in thread

From: Nathan Bossart @ 2024-09-16 21:11 UTC (permalink / raw)
  To: pgsql-committers@lists.postgresql.org

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(-)



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: pgsql: pg_upgrade: Parallelize retrieving relation information.
  2024-09-16 21:11 pgsql: pg_upgrade: Parallelize retrieving relation information. Nathan Bossart <nathan@postgresql.org>
@ 2024-09-17 19:59 ` Alexander Korotkov <aekorotkov@gmail.com>
  0 siblings, 0 replies; 4+ messages in thread

From: Alexander Korotkov @ 2024-09-17 19:59 UTC (permalink / raw)
  To: Nathan Bossart <nathan@postgresql.org>; +Cc: pgsql-committers@lists.postgresql.org

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





^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* pgsql: pg_upgrade: Parallelize retrieving loadable libraries.
@ 2024-09-16 21:11 Nathan Bossart <nathan@postgresql.org>
  0 siblings, 0 replies; 4+ messages in thread

From: Nathan Bossart @ 2024-09-16 21:11 UTC (permalink / raw)
  To: pgsql-committers@lists.postgresql.org

pg_upgrade: Parallelize retrieving loadable libraries.

This commit makes use of the new task framework in pg_upgrade to
parallelize retrieving the names of all libraries referenced by
non-built-in C functions.  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/46cad8b31927410a99894279ca9af4e0d5c185b6

Modified Files
--------------
src/bin/pg_upgrade/function.c | 71 +++++++++++++++++++++++++++----------------
1 file changed, 45 insertions(+), 26 deletions(-)



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* pgsql: pg_upgrade: Parallelize retrieving extension updates.
@ 2024-09-16 21:11 Nathan Bossart <nathan@postgresql.org>
  0 siblings, 0 replies; 4+ messages in thread

From: Nathan Bossart @ 2024-09-16 21:11 UTC (permalink / raw)
  To: pgsql-committers@lists.postgresql.org

pg_upgrade: Parallelize retrieving extension updates.

This commit makes use of the new task framework in pg_upgrade to
parallelize retrieving the set of extensions that should be updated
with the ALTER EXTENSION command after upgrade.  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/6ab8f27bc7163ab534543e32504e47ed924b6737

Modified Files
--------------
src/bin/pg_upgrade/version.c | 94 +++++++++++++++++++++++---------------------
1 file changed, 49 insertions(+), 45 deletions(-)



^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2024-09-17 19:59 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-09-16 21:11 pgsql: pg_upgrade: Parallelize retrieving relation information. Nathan Bossart <nathan@postgresql.org>
2024-09-17 19:59 ` Re: pgsql: pg_upgrade: Parallelize retrieving relation information. Alexander Korotkov <aekorotkov@gmail.com>
2024-09-16 21:11 pgsql: pg_upgrade: Parallelize retrieving loadable libraries. Nathan Bossart <nathan@postgresql.org>
2024-09-16 21:11 pgsql: pg_upgrade: Parallelize retrieving extension updates. Nathan Bossart <nathan@postgresql.org>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox