Downloads
Home   >   mailing lists

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

From Hannu Krosing
Subject Re: Horribly slow pg_upgrade performance with many Large Objects
Date
Msg-id CAMT0RQRT3KkwoQkx=YBdd_o9SqXxOt16fqQsscH_n+40Z57N7w@mail.gmail.com
Whole thread Raw
In response to Re: Horribly slow pg_upgrade performance with many Large Objects  (Nathan Bossart <nathandbossart@gmail.com>)
Responses Re: Horribly slow pg_upgrade performance with many Large Objects
List pgsql-hackers
Tree view 
Ah, I see.

I retried and now it runs for 21 to 29 seconds for 1 million large
objects with two grants each, 3M total rows inserted.

Yesterday it ran 8 seconds. Unfortunately I do not have the plan from
yesterday saved .

Anyway it looks like just dumping pg_shdepend it is better, and likely
also compresses very well for most users

--
Hannu

pgsql-hackers by date:

Previous
From: Hari Krishna Sunder
Date:
Subject: Re: Should TRUNCATE fire DDL triggers
Next
From: Damien Clochard
Date:
Subject: [PATCH] Generate random dates/times in a specified range