Re: improve performance of pg_dump with many sequences

From: Nathan Bossart <nathandbossart(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Michael Paquier <michael(at)paquier(dot)xyz>, Euler Taveira <euler(at)eulerto(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: improve performance of pg_dump with many sequences
Date: 2024-07-24 18:36:34
Message-ID: ZqFJspSbieuTE4X0@nathan
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I ran Euler's tests again on the v6 patch set.

for i in `seq 1 10000`; do psql postgres -c "CREATE SEQUENCE s$i;"; done
time pg_dump -f - -s -d postgres > /dev/null

HEAD: 0.607s
0001 + 0002: 0.094s
all patches: 0.094s

Barring additional feedback, I am planning to commit these patches early
next week.

--
nathan

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Muhammad Malik 2024-07-24 18:44:04 Regarding t_cid in Neon heap WAL records
Previous Message Tom Lane 2024-07-24 18:31:41 Re: warning: dereferencing type-punned pointer