Pg_upgrade performance - Mailing list pgsql-hackers

From Mark Kirkwood
Subject Pg_upgrade performance
Date
Msg-id 4C983131.2070603@catalyst.net.nz
Whole thread Raw
Responses Re: Pg_upgrade performance  (Mark Kirkwood <mark.kirkwood@catalyst.net.nz>)
List pgsql-hackers
I've been having a look at this guy, trying to get a handle on how much 
down time it will save.

As a quick check, I tried upgrading a cluster with a 1 non default db 
containing a scale 100 pgbench schema:

- pg_upgrade :         57 s
- pgdump/pg_restore : 154 s

So, a reasonable saving all up - but I guess still a sizable chunk of 
downtime in the case of a big database to copy the user relation files.

I notice there is a "link" option that would be quicker I guess - would 
it make sense to have a "move" option too? (perhaps with pg_upgrade 
writing an "un-move" script to move them back just in case).

Regards

Mark


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: .gitignore files, take two
Next
From: David Fetter
Date:
Subject: Re: Path question