Postgres Pro
Downloads
Home   >   mailing lists

Re: [PATCH] pg_dump: lock tables in batches - Mailing list pgsql-hackers

From Andres Freund
Subject Re: [PATCH] pg_dump: lock tables in batches
Date
Msg-id 20221207213242.muei2rkds3ybngaf@awork3.anarazel.de
Whole thread Raw
In response to Re: [PATCH] pg_dump: lock tables in batches  (Fabrízio de Royes Mello <fabriziomello@gmail.com>)
Responses Re: [PATCH] pg_dump: lock tables in batches  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers
Tree view 
Hi,

On 2022-12-07 18:14:01 -0300, Fabrízio de Royes Mello wrote:
> Here we have some numbers about the Aleksander's patch:

Hm. Were they taken in an assertion enabled build or such? Just testing the
t10000 case on HEAD, I get 0:01.23 elapsed for an unpatched pg_dump in an
optimized build. And that's on a machine with not all that fast cores.

Greetings,

Andres Freund

pgsql-hackers by date:

Previous
From: Andrey Borodin
Date:
Subject: Re: Transaction timeout
Next
From: Greg Stark
Date:
Subject: Re: Temporary tables versus wraparound... again