This page is not created by, affiliated with, or supported by Slack Technologies, Inc.
2020-01-27
Channels
- # announcements (10)
- # aws (11)
- # beginners (158)
- # calva (8)
- # cider (14)
- # clj-kondo (1)
- # cljsrn (1)
- # clojure (83)
- # clojure-europe (5)
- # clojure-italy (25)
- # clojure-nl (3)
- # clojure-spec (12)
- # clojure-uk (20)
- # clojurescript (72)
- # community-development (18)
- # core-async (4)
- # core-logic (19)
- # cursive (11)
- # datomic (21)
- # duct (6)
- # events (1)
- # figwheel-main (3)
- # fulcro (15)
- # ghostwheel (1)
- # jobs (1)
- # leiningen (16)
- # off-topic (45)
- # onyx (3)
- # pathom (7)
- # perun (1)
- # ring (3)
- # shadow-cljs (48)
- # spacemacs (10)
- # specter (1)
- # sql (24)
- # tools-deps (7)
- # vscode (7)
- # xtdb (14)
Aurora doesn’t seem to support in place major upgrades which seems off. I’d probably start with plain multi-az rds and see how it feels like...
We don’t have a DBA on the team so my main fear with Postgres is that we’ll mess up :)
Yes, keep an eye on maintanence windows, and plan for it. We have multi-region A-Z setups
Are you using read replicas of any sorts? I was surprised to see that the multi-az setup, the second instance is only on standby and can’t serve traffic.
So it seems that the only possible scaling is via read replicas with some lag, or scaling up for bigger machines.
Not really concerned for my needs, just checking to see if I have an accurate picture...
I consume millions of events per day and the CPU on the instance never goes about 4-5%
running around dozen postgres instances (often with read replicas or even many) on rds in production. i'm really happy i don't have to manage those machines by hand, can spend my time elsewhere.
for only very big postgres instances we run separate boxes, there it becomes financially reasonable to host your own
from the default settings of read replicas - you probably want to increase the time interval that the replicas allow queries to run, the default is something super low , like 30 or 60 seconds. if you use a read replica as a reporting database you probably will have queries that run for several minutes.