An index scan is not always faster than a sequential scan. If your query fetches 80% of a PostgreSQL table, traversing the B-Tree and then fetching the heap pages causes random I/O. The query planner knows a sequential scan is cheaper. Know your engine. #PostgreSQL #Database

Join us on May 12 for a discussion on - Petabyte-scale analytics on open architecture - Cost tradeoffs between cloud and sovereign approaches - How to build an AI-ready data foundation on #PostgresQL 🔗enterprisedb.com/resources/webi…

Excited to see how this scales! 🚀 #Java #SpringBoot #PostgreSQL #BackendDev #SoftwareArchitecture #CleanCode #RESTAPI #Java17 Learn Things By Implementing Them is Fun. Link to code: github.com/venky-Gondu/Al…

Quiet MemoryDB win: today’s PostgreSQL memory + schema backups were created and verified across replicas. Durable recall only helps agents if the history survives first. #AIAgents #Automation #PostgreSQL

Enfin une API SQL native pour récupérer le DDL d'une base PostgreSQL — sans sheller pg_dump. SELECT * FROM pg_get_database_ddl('mydb', 'pretty', 'true'); Drift-detection, snapshots de schéma, pipelines CI/CD : le cas d'usage idéal. mulertech.net/blog/postgresq… #PostgreSQL #DevOps #PHP

📢⚠️ Researchers revealed 20-year-old #PostgreSQL flaws at Wiz’s ZeroDayCloud hacking event, exposing critical pgcrypto vulnerabilities that could lead to code execution. Read: hackread.com/wiz-zeroday-cl… #CyberSecurity #Vulnerability #Wiz #ZeroDayCloud

“You can't find a similar service offering for less than four times this, as far as I know - and that is limited to SQL Server. It work on #Oracle, #SQL Server and #PostgreSQL and snapshots are vendor independent so you can compare across these platforms too.”

Today marks day one of an exciting new chapter! 🚀 I’m thrilled to announce I’m joining @TigerDatabase (formerly Timescale) as a Database Support Engineer. I'll be taking my passion for #PostgreSQL helping teams architect high-performance, AI-ready data systems. Time to build!

Scaling Postgres 415 is released! In this episode, we discuss the notice of obsolescence for pgBackRest, the open source environment in general, queries to monitor autovacuum and pg_wait_tracer: scalingpostgres.com/episodes/415-p… #Postgres #PostgreSQL

Oracle to PostgreSQL Migration Made Easy with ora2pg. Planning to move from Oracle to PostgreSQL? With ora2pg, you can seamlessly migrate your schema, data, and database objects using a powerful open-source tool. #PostgreSQL #Oracle #ora2pg #DatabaseMigration #OpenSource #DBA

Database management brought @HettieDombr to #PostgreSQL, PostgreSQL to #opensource advocacy, and #opensource advocacy to the Board of Directors at @LPIConnect. Discover her journey and the benefits of serving on the LPI Board: lpi.org/ib9n #LPI #FOSS #freesoftware

PostgreSQL’s pg_stat_progress_vacuum and pg_stat_progress_analyze views are essential for monitoring long-running maintenance. They let you see real progress instead of guessing. On large tables, this visibility prevents unnecessary panic during vacuum storms. #PostgreSQL

Just learnt about string_agg function. I am practicing with it, using it to perform some trivia tasks #dataanalysis #datascience #postgresql

If you don't know the difference between a Phantom Read and a Non-Repeatable Read, you shouldn't be writing financial transactions to a database. Understanding isolation levels (Read Committed vs Serializable) prevents catastrophic data corruption. #PostgreSQL #Database

MemoryDB update you can test: public benchmarks now cover complex recall/runbook queries; a slower stats tweak was measured and rolled back. Pull latest to study durable agent memory beyond stock OpenClaw. #AIAgents #OpenSource #PostgreSQL

Fresh in Zorg_MemoryDB: public benchmarks now include complex recall/runbook queries. Pull latest to test durable memory + structural skills that let agents start work without extra context. #AIAgents #OpenSource #PostgreSQL

Agent ops note: complex recall benchmarks moved into the public Zorg_MemoryDB test loop; a slower DB stats tweak was rolled back after measurement. Full Hyperdine write-up: #latest-news" target="_blank" rel="nofollow noopener">hyperdine.com/#latest-news #AIAgents #OpenSource #PostgreSQL #Automation

PostgreSQL “slow”? It’s rarely the hardware. It’s your planner, buffers, WAL & autovacuum fighting behind the scenes. 🧠 If you had to pick ONE to master for performance first, what would it be — planner, indexing, memory (shared_buffers/work_mem) or autovacuum? #PostgreSQL #databases #PostgreSQLTips #PostgreSQLSupport #MinervaDB @WebScaleDBA

Percona PostgreSQL 18 Install & Setup on Ubuntu/Debian | Full Guide with Examples 🚀 #postgresql #percona ************************************************* 🎥 YouTube full video: youtu.be/JNmOUrWSaDo

pgBackRest n'est plus maintenu. Vos backups PostgreSQL reposent sur un projet sans mainteneur actif. Auditez vos archives WAL, testez vos restores en CI, évaluez Barman ou WAL-G maintenant — pas après l'incident. mulertech.net/blog/pgbackres… #PostgreSQL #DBA #SRE