I am thinking of breaking #Postgres and #ElasticSearch to a separate server instead of increasing my current VPS resources.
I'll have two servers. My main, which will run Mastodon, and another that will have Postgres and ElasticSearch on it.
Will I benefit by doing this or should I just move ElasticSearch to its own server? What is the minimum CPU/ram I can get for the second server & what should I get?
🚀 I just published a short guide explaining how to upgrade PostgreSQL 🐘 from version 15 to 16 just after an upgrade to Ubuntu 24.04 LTS (Noble Numbat) 🦘
This weekend, I hacked together a markdown documentation generator for Postgres in Go. It should be extensible to other databases, as well as including other properties from database.
(I'm taking bets that I can build this based on SQLite if I set my mind to it I learned a lot of creative database stunts at #postgres meetups and now from #clickhouse and I'm telling you folks a database is a framework to be used to build platforms not to just passively sit there in a corner hidden behind a cache databases aren't some mimimi :)
Anyone here used both #MySQL and #Postgres a lot and could tell me how they compare for larger DBs? Mostly in terms of performance, assuming I don't need some advanced features - talking about 10s or 100s of GBs, a lot of writes but not that many reads. 🤔 #PostgreSQL
This is the best pic I have of the late Simon Riggs who passed away yesterday 26 Mar 2024. 💔 Simon's far-reaching influence in the Postgres world changed the course of so many lives. I took this photo when Simon was giving his Postgres keynote at #PGConfEU 2023 last December in Prague. RIP Simon, you will be missed by so many people, whose hearts are broken right now 💔
A mentor, colleague, friend, and extraordinary person. I am heartbroken and beyond words at the passing of Simon Riggs. My deepest condolences to his closest and loved ones.
. @dgapitts wants to organize #postgres meetups in Barcelona and Madrid and is looking for support, speakers, anything you can give. Friends in Spain?! @pgDayParis
📢 This week: "Recovering from Data Loss Despite Not Having a Backup: A Postgres True Story" 📆 Friday March 15 at 17:00, Ballroom H @ #SCaLE21x — see you there!
It’s official 🐘 I am on my way ✈️ to @nordicpgday & #pgDayParis—and I am so excited 🎉🥳 to see some of my #PostgreSQL favorites—and to meet new ppl in the PG community too.
At Nordic I will give a beginners guide talk about partitioning & sharding—and in Paris I’ll give a lightning talk about fighting the butterflies & giving your first Postgres conference talk.