This page is not created by, affiliated with, or supported by Slack Technologies, Inc.
2020-01-28
Channels
- # babashka (28)
- # beginners (252)
- # bristol-clojurians (2)
- # calva (28)
- # cider (11)
- # clj-kondo (15)
- # cljs-dev (7)
- # clojure (378)
- # clojure-europe (4)
- # clojure-italy (4)
- # clojure-nl (3)
- # clojure-norway (4)
- # clojure-uk (32)
- # clojurescript (128)
- # cursive (39)
- # data-science (18)
- # docker (37)
- # figwheel-main (10)
- # fulcro (45)
- # ghostwheel (7)
- # graalvm (2)
- # hugsql (1)
- # jobs (2)
- # joker (5)
- # kaocha (5)
- # luminus (12)
- # off-topic (37)
- # onyx (4)
- # pathom (22)
- # pedestal (70)
- # re-frame (7)
- # reagent (30)
- # ring (4)
- # shadow-cljs (12)
- # spacemacs (1)
- # sql (26)
- # tools-deps (7)
- # vrac (2)
- # vscode (7)
- # xtdb (27)
@kulminaator have your instances had their autovacuum settings readjusted from the defaults?
Yes we have had adjustments on those too, depending on apps
On some we probably will go for additional automated vacuums from apps too.
So it’s not 100% worry-free, right? In the sense that I pay someone else to worry about tuning and tweaking and settings.
I’m not too opposed to have to learn a few things, and it seems AWS limits the parameters you can tweak which is probably a good idea. They also have “Performance Insights” now which might help for some use cases. But it seems like I’d need to have some support from a DBA every once in a while.
imho, if one is running any system, be it mysql, mariadb, postgresql, mongodb etc.., then having at least some understanding of how it works (where it works well, and where it does not) is still important, even with SaaS offerings
I dont think any storage is worry free, but it is easier than just postgres clusters on top of ubuntu and chef infra. That requires way more.
Oh yeah I’m just spoiled because we use Mongo Atlas and Mongo ObjectRocket and they take care of mostly everything. Apart from storage/instance size/IO there’s not much else to tweak
My team is pretty solid on db stuff, so i'm not too worried.
If you want to do fast rollover upgrades then dont forget to enable logical replication so you can stream data to a newer instances via their db migration tool.
Talking of fancy stuff, anyone using cockroachdb with java or clojure ? Happy / not happy ?
Name is horrible but design seems good
[UPDATE import.spaces (id, import_timestamp, record, table_name) VALUES (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?) 89dc51b1-9763-4ffc-99e3-a435d34f58aa #inst "2020-01-28T16:06:57.000000000-00:00" {"foo":"onelkajsdlfkjalskdjflkajsdf"} spaces 05566595-1703-4eb3-acb7-5ef56d8fcd95 #inst "2020-01-28T16:06:57.000000000-00:00" {"foo":"twokdsksksksk"} spaces 1832fe59-a0c9-42b8-871d-143c344c9993 #inst "2020-01-28T16:06:57.000000000-00:00" {"foo":"thsksksksksksk"} spaces]