Condor <[email protected]> writes: > On 26-07-2016 21:04, Dorian Hoxha wrote: > >> Many comments: https://news.ycombinator.com/item?id=12166585 >> https://www.reddit.com/r/programming/comments/4uph84/why_uber_engineering_switched_from_postgres_to/ >> >> On Tue, Jul 26, 2016 at 7:39 PM, Guyren Howe <[email protected]> wrote: >> >>> Honestly, I've never heard of anyone doing that. But it sounds like >>> they had good reasons. >>> >>> https://eng.uber.com/mysql-migration/ >>> >>> Thoughts? >>> >>> -- >>> Sent via pgsql-general mailing list ([email protected]) >>> To make changes to your subscription: >>> http://www.postgresql.org/mailpref/pgsql-general > > > They are right for upgrades. > It's a hard to shutdown 1 TB database and wait couple of days > pg_upgrade to finish upgrade and meanwhile database is offline. > In some distros after upgrade of PG version you don't have old binary > and library, need to do full dump and restore that take time and disk > space.
Yeah, very hard indeed when done by unskilled DBAs :-) I've done several ~7TB pg_upgrades and with the hard link option and a framework that parallelizes the post-analyzer phase... ...45 minutes till completion. > > Regards, > Hristo S. -- Jerry Sievers Postgres DBA/Development Consulting e: [email protected] p: 312.241.7800 -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
