💫 Introducing pgEdge Starfleet: a #Postgres cloud platform built to take AI apps from prototype to production. Start with a single database, add built-in #MCP & #RAG servers, and deploy in production on pgEdge-hosted cloud, your cloud, or on-prem.

www.pgedge.com/press-releas... #PostgreSQL #Tech

Supabase rolls Postgres 15.19/17.11 out to every project starting today, closing 44 CVEs and flagging four breaking changes that need manual follow-up.

#Firebase #Supabase #Postgres #Security

Postgres local sin Docker con Tinbase

¿Docker te come toda la RAM? Corré postgres local sin docker con un binario de 58 MB que arranca en 2,5 segundos, así lo probaron con Tinbase

#tinbase #postgres #supabase #docker #desarrollolocal

Adding a column is safe. Adding a NOT NULL column with a default is how teams take their own site down at 2am.

A full table rewrite takes an ACCESS EXCLUSIVE lock. On 4M rows that blocks every read and write.

Staging had 800 rows.

#postgres #database

Every test in our suite opened a connection and ran migrations, so the runtime tracked infrastructure, not logic. Here is how we cut the database out of tests that never needed it.

#testing #pytest #postgres

PlanetScaleがPostgres向け全文検索「TIN」を出した理由
https://papoo.work/doc/d625dee51ba0a60b
#postgres #全文検索 #データベース #検索エンジン #性能比較

PlanetScaleがPostgres向け全文検索「TIN」を出した理由
https://papoo.work/doc/d625dee51ba0a60b
#postgres #全文検索 #データベース #検索エンジン #性能比較

Your weekend watch is “Postgres for the Lakehouse: pg_lake” with Marco Slot:

www.youtube.com/watch?v=feYg...

#PostgreSQL #postgres

PlanetScaleがPostgres向け全文検索「TIN」を出した理由
https://papoo.work/doc/d625dee51ba0a60b
#postgres #全文検索 #データベース #検索エンジン #性能比較

Still on the fence about attending Postgres Summit US? Not sure how to approach your manager about conference expenses? We make it easy! Check out our “Make the Case” page. It contains all the information you need!

2026.postgressummit.us/attend/justi...

#PostgreSQL #postgres #conference

The next Postgres Meetup for All will be on Thursday, October 1st! That’s 1 week from today! Join us for “DIY Postgres Branching” with Radim Marek:

www.meetup.com/postgres-mee...

#PostgreSQL #postgres

Your ORM is making N+1 queries and your tests will never catch it.

10 rows: 11 queries, 4ms, green. 4000 rows: 4001 queries at 0.4ms each, and a p99 nobody can explain.

Count queries in tests. Don't time them.

#postgres #orm

PGX is proud of our commitment to the PostgreSQL Community. That's why we encourage each of our employees to volunteer for PgUS and its affiliated conferences and User Groups.

pgexperts.com/corporate/co...

#PostgreSQL #postgres

Our affiliated PUGs are looking for speakers! If you're local to one of the PUGs listed here: www.meetup.com/pro/postgres... and would like to present, contact us and we can put you in touch with the organizers!

buff.ly/4gfy2M3

#PostgreSQL #postgres

A single atomic migration script cannot keep a site up. Old and new code must both work against the schema during rollout, so the change belongs in two deploys.

#postgres #migrations #deploys

Tonight! PostgreSQL Edinburgh September meetup, with talks by @danielroe.dev and @vyruss.org!
🔽
cloomba.com/e/postgresed...

#PostgreSQL #Postgres #Edinburgh #Scotland #Meetup

4BモデルにPostgres超えのクエリプランを学習させた話
https://papoo.work/doc/4a44c8085d17f4a3
#postgres #データベース #クエリ最適化 #機械学習 #強化学習

274 lines of Python that dumps Postgres and pushes it to S3. Cron-friendly, good for sysadmins who'd rather not write it themselves. https://www.valtersit.com/python/database-backup-scheduler-with-s3-upload/ #python #postgres #s3

We're getting ready for NYC! Bruce Momjian, Gabriele Bartolini, Devrim Gunduz, Gabriele Fedi, Xavier Fischer all have sessions on the schedule. Make sure to drop by the booth, we're participating in the "sponsor passport raffle"! www.enterprisedb.com/blog/big-app... @pgsummitus.bsky.social #Postgres