Re: Ought to use heap_multi_insert() for pg_attribute/dependinsertions? - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Ought to use heap_multi_insert() for pg_attribute/dependinsertions?
Date
Msg-id 20190611232636.meub2arerhq3s7mb@alap3.anarazel.de
Whole thread Raw
In response to Re: Ought to use heap_multi_insert() for pg_attribute/dependinsertions?  (Daniel Gustafsson <daniel@yesql.se>)
List pgsql-hackers
Hi,

On 2019-06-11 15:20:42 +0200, Daniel Gustafsson wrote:
> Attached is an updated version with some of the stuff we briefly discussed at
> PGCon.  This version use the ObjectAddresses API already established to collect
> the dependencies, and perform a few more multi inserts.

Cool.

> Profiling shows that
> we are spending less time in catalog insertions, but whether it’s enough to
> warrant the added complexity is up for debate.

Probably worth benchmarking e.g. temp table creation speed in
isolation. People do complain about that occasionally.

Greetings,

Andres Freund



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: pgbench rate limiting changes transaction latency computation
Next
From: Kyotaro Horiguchi
Date:
Subject: Re: pg_upgrade: prep_status doesn't translate messages