Downloads
Home   >   mailing lists

Re: Horribly slow pg_upgrade performance with many Large Objects - Mailing list pgsql-hackers

From Nathan Bossart
Subject Re: Horribly slow pg_upgrade performance with many Large Objects
Date
Msg-id aG6srPib60NzJBeg@nathan
Whole thread Raw
In response to Re: Horribly slow pg_upgrade performance with many Large Objects  (Hannu Krosing <hannuk@google.com>)
Responses Re: Horribly slow pg_upgrade performance with many Large Objects
List pgsql-hackers
Tree view 
On Wed, Jul 09, 2025 at 04:52:16PM +0200, Hannu Krosing wrote:
> If you run it without the last WHERE it is reasonably fast. And it
> behaves the same as just inserting from the dump which also does not
> have any checks against duplicates.

With that change, the query is much faster, but my testing indicates that
it's still measurably slower than dumping and restoring the relevant
contents of pg_shdepend.

-- 
nathan

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Fix comment in btree_gist--1.8--1.9.sql
Next
From: Andres Freund
Date:
Subject: Re: Adding basic NUMA awareness - Preliminary feedback and outline for an extensible approach