Clojurians Log v2

@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.

Yeah, it's probably the most important thing to tune for PostgreSQL

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

Everything needs tweaking to suit particular use cases 🙂

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.

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 ?

Thanks for the tip, I’ll look into that

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

Tis a horrible name

It's just another hard sell to the boss - cockroach db?

I mean, pick a nicer sounding name

DuracellBunnyDB

keeps on going and going and going....

I mean, it’s persistently alive 🙂

Name is horrible but design seems good

Anyone have advice on updating (batch) multiple rows via psql?

[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]

I tried something like this but it doesn’t seem to work

that isn't correct sql syntax for update, that is insert syntax with the word update in front of it

Figured it out, thanks @hiredman