New blog post https://pgdba.org/post/2025/04/size_matter/
#PostgreSQL #Database #memory #configuration #dba #databaseadministration #dataengineering

We recently wrote about scaling MySQL using replicas.

Article: https://victoronsoftware.com/posts/mysql-master-slave-replication/

Video: https://www.youtube.com/watch?v=mpCeatW4t_U
#DatabaseAdministration #MySQL #DatabaseScaling

We updated our MySQL replication article for the latest MySQL versions (8.0, 8.4, and 9.1)

https://victoronsoftware.com/posts/mysql-master-slave-replication/
#DatabaseAdministration #MySQL #DatabaseScaling

GREAT NEWS: We'll have an openSUSE booth at DataCon LA again this year. This time the event will be on Nov 16th, 2024 at CSULB! Yep, it's in Long Beach this time AND not in the heat of summer! If anyone is interested in helping out at the booth, please let me know.

#opensuse #linux #gnulinux #sysadmin #devops #cloudcomputing #databaseadministration #bigdata #databases #longbeachca #losanageles #csulb #calstatelongbeach #datacon2024 #event

It's time for "Take your #pgBadger usage to the next level: discover the potential of #Postgres for log analysis like never before!" at the real-time livestream of @pgdaylowlands - learn from Henrietta Dombrovskaya about improving log analysis and performance optimization with pgBadger.

https://www.youtube.com/live/ZPR7u44YJKI

#PostgreSQL #Postgres #DBA #databaseadministration #opensource #foss #techtalks #techwebinar #techmeetup #techevent #logging #appdev #pgbadger #SQL #learnSQL #audit #logging #tech

Next up to watch on the livestream at @pgdaylowlands is @jriou - he's presenting about "Efficient Time Series Management with #TimescaleDB at @mipsytipsy

https://www.youtube.com/live/ZPR7u44YJKI

Happening now!

Subscribe to @pgdaylowlands to watch the recording to be posted later on 🐘

#timeseries #opensource #foss #database #datamanagement #databaseadministration #dba #sql #rdbms

Are you listening? Jérémie Grauer is speaking at @pgdaylowlands about "#Postgres nightmare stories" - listen in on the livestream: https://www.youtube.com/live/ZPR7u44YJKI

Next up: "Efficient Time Series Management with #TimescaleDB at @OVHcloud with @jriou

#datamanagement #sql #postgresql #dba #databaseadministration #database #learnsql #techwebinar #learntech #tech #opensource #foss #timeseries #timescale

Database scaling issues are challenging to discover in development. We recently wrote about the top DB issues we hit.
#SQLPerformance #SQLDeveloper #DatabaseScaling #MySQL #DatabaseAdministration
https://buff.ly/45a8Gdl

We hit these database issues when scaling applications:
- Excessive database locks
- Read-after-write consistency
- Index limitations
#SQLPerformance #SQLDeveloper #DatabaseScaling #MySQL #DatabaseAdministration
https://buff.ly/45a8Gdl

Recently, I wrote about fixing a slow MySQL query doing an INSERT with subqueries.
#MySQL #SQLDeveloper #SQLPerformance #DatabaseAdministration
https://buff.ly/3ypqyom

Try scaling your database using master-slave replication in your dev environment
#MySQL #DatabaseScaling #DatabaseAdministration
https://buff.ly/4bqBbpE

PostgreSQL 16 Administration Cookbook now available on Amazon.com with a 25% discount! 📚✨ I will also be signing it at PGDay Chicago this Friday after my talk! Grab your copy now at https://packt.link/E7qyn 🛒

Come to PGDay Chicago: https://2024.pgdaychicago.org/

#PGDayChicago #PostgreSQL #Postgres #OpenSource #Database #DatabaseManagement #DatabaseAdministration #DBA #SQL

📚 Don't miss out on the PostgreSQL 16 Administration Cookbook! By @vyruss and @tchorix 📚 Get your hands on expert tips and tricks for managing PostgreSQL databases. 🚀 Hurry, the discount is available only until the 22nd! ⏳ Grab your copies now and level up your administration skills!
and use code: 20JIMMY for the discount. We hope this is useful.

Get your copies: https://packt.link/iKm8Y

#databases
#opensource
#databaseadministration
#postgresql
#postgresql_conference

@fosdem 2024 was once again a great opportunity to learn about #PostgreSQL and interact with the #Postgres #community. I also had the great pleasure to meet many fellow enthusiasts at the PostgreSQL Europe booth, where I was joined by friend and comrade-in-arms @tchorix and we took the opportunity to do an impromptu book signing for "PostgreSQL 16 Administration Cookbook" which we co-authored 👉 https://packt.link/BmLOz

#conference #techbooks #fosdem #dba #databaseAdministration #sql

Video premiering now! We get together with @tchorix to discuss our new book:
https://youtu.be/HuHkOSXu_rM

#PostgreSQL #DatabaseAdministration #Cookbook #Postgres #OpenSource #Database #Book #DBA #DatabaseAdministrator

@tchorix and I got together to discuss our new book! Full video to follow later today: https://www.youtube.com/shorts/TUQi0Kc3smU

#PostgreSQL #DatabaseAdministration #Cookbook #Postgres #OpenSource #Database #Book #DBA #DatabaseAdministrator

Happy #DBA #Appreciation Day! If you don't know who to thank today, thank your #Database #Administrators. They keep stuff running 24/7!

https://dbaday.org/

#DBADay #administration #administrator #databases #DatabaseAdministration #PostgreSQL #postgres #MySQL #oracle #SQLServer #DB2 #MariaDB

DBA a life in the shadows
Database administration is weird. The job is a strange combination of theory and practice, strictness and loose rules mixed together in a magic blend.

The DBA is probably one of the most obscure and one of the less appreciated roles within the IT organisations.

Today is the day to say thank you to your DBA!

https://dbaday.org/

#dba #dbaday #databaseadministration #postgresql #mysql #oracle #sqlserver #firebird

Referenced link: https://hackernoon.com/log-slow-postgres-query-plans-automatically-an-introduction-to-auto-explain
Discuss on https://discu.eu/q/https://hackernoon.com/log-slow-postgres-query-plans-automatically-an-introduction-to-auto-explain

Originally posted by HackerNoon | Learn Any Technology / @hackernoon@twitter.com: https://twitter.com/hackernoon/status/1573510039188512775#m

"Log Slow Postgres Query Plans Automatically: An Introduction to auto-explain" by @scalegridio https://hackernoon.com/log-slow-postgres-query-plans-automatically-an-introduction-to-auto-explain #databaseadministration #postgresql