So I'm back from sailing and today is PGSQL Phriday (weird spelling I know) and the topic for today's community Postgres blogging event is "Partitioning vs. Sharding", a topic that is right up my alley!

So here is my blog contribution on Understanding Partitioning and Sharding in Postgres, featuring the Citus database extension in the sharding section of course!

#PostgreSQL #PGSQLPhriday #Citus #databases #OpenSource #blogging #Postgres

https://www.citusdata.com/blog/2023/08/04/understanding-partitioning-and-sharding-in-postgres-and-citus/

I haven’t posted in a while and this is why: Sailing in Greece, luckily far away from the devastating fires which raged in other islands. Now I’m back in the saddle and working on my #PGSQLPHriday post about Partitioning vs Sharding in #PostgreSQL.

#PostgreSQL #Postgres #sailing #greece

This week #pgsqlphriday is about the famous pgBadger for log analysis. I share some of my views on it at: https://e7e6.github.io/posts/pgbadger_pgsqlphriday/ .

A very useful addition to your toolbelt if you've not used it before. Just don't think it's the only one you will ever need.

#PostgreSQL #pgBadger

#PGSQLPhriday number 10: pgBadger

https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/pgsql-phriday-010-you-re-invited-to-dive-into-the-world-of/ba-p/3859744

#Postgres #PostgreSQL

This week's #PGSQLPhriday is about pg_stat_statements (hosted by @michristofides ), here is my take on it: https://e7e6.github.io/posts/pg_stat_statements_pgsqlphriday/ .

Here are my two (2) #PGSQLPhriday entries:

🎙️ https://postgres.fm/episodes/pg_stat_statements

📝 https://www.pgmustard.com/blog/queries-for-pg-stat-statements

I need a lie down now

New episode: “pg_stat_statements”

This week we discuss the most popular #postgres extension! Not only why everyone should use it, but also some downsides.

🎙️ https://postgres.fm/episodes/pg_stat_statements

📺 https://youtu.be/t4Eh1ggrMXo

#postgresql #pgsqlphriday

I'm proud to be the host of this month's #PGSQLPhriday event.

The topic this month will be: pg_stat_statements

All are welcome, including (especially) folks who haven't blogged in a while!

The date to post is a week tomorrow (or a week today, if you're in GMT+ALOT)

Here's my invitation post with more details: https://www.pgmustard.com/blog/pgsql-phriday-pg-stat-statements

#PostgreSQL #Postgres

Hello,

Here is my opinion about triggers! https://mydbanotebook.org/post/triggers-and-me/

#PGSQLPhriday

Hello!
I'm #PGSQLPhriday host this month!
Check out your challenge here: https://mydbanotebook.org/post/triggers/

#PGSQLPhriday 006: What I Wish I Knew While Learning #PostgreSQL - Grant Fritchey https://www.scarydba.com/2023/03/03/pgsqlphriday-006-what-i-wish-i-knew-while-learning-postgresql/

#PGSQLPhriday 006: Wrap Up & Summary - Grant Fritchey https://www.scarydba.com/2023/03/06/pgsqlphriday-006-wrap-up-summary/ #postgresql

Grant Fritchey: #PGSQLPhriday 006: What I Wish I Knew While Learning PostgreSQL https://www.scarydba.com/2023/03/03/pgsqlphriday-006-what-i-wish-i-knew-while-learning-postgresql/
#postgres #postgresql

Grant Fritchey: #PGSQLPhriday 006: Wrap Up & Summary https://www.scarydba.com/2023/03/06/pgsqlphriday-006-wrap-up-summary/
#postgres #postgresql

One thing I wish I knew earlier when learning PostgreSQL: Avoiding VARCHAR columns with maximum character lengths. https://www.stevencanplan.com/2023/02/avoid-varchar-columns-in-postgresql-pgsql-phriday-006/ #PGSQLPhriday

The topic for #pgsqlphriday 006 is out! This month's host is Grant Fritchey:

"One thing you wish you knew while learning Postgres"

Only one... Hm... Can't wait to read the contributions!

#postgres #postgresql

https://www.scarydba.com/2023/02/24/one-thing-you-wish-you-knew-while-learning-postgresql-pgsqlphriday-006/

#PgSQLPhriday 005 recap! 🐘

Thanks for contributing!
@michristofides @ryanbooz @ascherbaum @intrbiz and more that I don't think are here on Mastodon

#PostgreSQL #Postgres

https://blog.rustprooflabs.com/2023/02/pgsql-phriday-005--recap

I finally managed a #PGSQLPhriday submission — Storing blobs in #PostgreSQL (for our saved plans feature) https://www.pgmustard.com/blog/storing-blobs-in-postgres

My post for #PGSQLPhriday where Ryan asked about using PostgreSQL for non relational data:
https://nexteam.co.uk/post/technology/postgresql/postgresql-not-always-relational

Relational and Non-relational Data: PGSQL Phriday #005

#PostgreSQL #PGSQLPhriday

https://andreas.scherbaum.la/blog/archives/1132-Relational-and-Non-relational-Data-PGSQL-Phriday-005.html