Is the database working as expected?

#meta #postgres

If you are reading this, the answer is yes.

We just updated our Postgres version, so I'm thankful nothing went wrong.

Latest comments (20)

Charles Reace • Oct 18 '19

Postgres...I've become a big fan of materialized views, lately. 😊

KP • Oct 17 '19

Thanks for the detailed explanation! I don't come from the ROR community so Postgres is foreign to me...and I know a lot of people that fall inthe same boat. Your answer was helpful, so thanks.

KP • Oct 16 '19

Just curious why dev is using postgres vs mysql. What are the benefits?

FullSendMic • Oct 16 '19

♥️

TuWang • Oct 16 '19

Absolutely

rhymes • Oct 16 '19

I know, but Heroku prudently keeps that for 3 months in beta.

I guess we'll have to upgrade again next year :P

Luke Garrigan • Oct 16 '19

woo well done! 🥳

Felippe Regazio • Oct 16 '19

Yes

Renato Byrro • Oct 16 '19 • Edited

Some features were down (now good) for a few minutes:

Dashboard inaccessible
Wouldn't save changes to an article
Unpublished articles were not accessible (reading draft or editing)

Yes, guilty, I'm a heavy user and needed all this during your 2-minute migration window 😊

Ben Halpern • Oct 16 '19

We could have optimized for a time where we had less traffic, like late Friday night, but since we hadn't performed this kind of upgrade before we felt like optimizing for a time where most of the team could be online and alert made sense.

The next time we need scheduled downtime (or, gasp! face unscheduled downtime) we will likely have way more users online at all times. This kind of thing isn't getting easier.