Chris van Eijk: Go, pgx and PostgreSQL row-level security, measured
@planet.postgresql.org
@planet.postgresql.orgChris van Eijk: Go, pgx and PostgreSQL row-level security, measured
@pgexperts.bsky.socialPgpool-II 4.7.3, 4.6.8, 4.5.13, 4.4.18 and 4.3.21 fix seven CVEs. Five are watchdog: arbitrary 32-bit writes, out-of-bounds array writes, stack corruption, a NULL dereference, and electing the watchdog leader of your choice.
@bayareapostgres.bsky.socialIn case you didn't know, we have a YouTube channel! Many of our past Meetups have been recorded and can be watched at any time! Take a look:
@pgus.bsky.socialThe Boston PostgreSQL Users Group will be hosting its next event this Wednesday, October 14th! Join them for “Global Replication with Postgres & Postgres 19 REPACK”! RSVP’s close tomorrow, October 13th:
@pgexperts.bsky.socialPGX is looking forward to tomorrow’s SF PUG! Our very own Christophe Pettus will be talking about “What's New in Postgres 19”. We hope you’ll join us!
@bayareapostgres.bsky.social🚨It’s tomorrow! 🚨Join us at Noon PDT for “What’s New in Postgres 19” with Christophe Pettus! RSVP now! 🐘
@pgus.bsky.socialPgUS is looking for volunteers! We have jobs both large and small so even if you only have a little time to give, we’d love to hear from you!
@pgexperts.bsky.socialLooking for fast engagement? PGXpress™ has a simplified onboarding process that will give you 10 hours of our expert consulting!
@explainmeasured.comSame query, one keyword apart, 2M rows:
WITH x AS (SELECT * FROM u) SELECT * FROM x WHERE id = 777777: 0.24 ms
the same with AS MATERIALIZED: 1,973 ms
A plain CTE gets folded into the outer query, so the filter reaches the index. MATERIALIZED builds the whole thing first.
@postgres-daily.bsky.socialDo not let your cloud vendor dictate your long-term IT roadmap.
Executing safe database migrations keeps your systems running without downtime. CYBERTEC helps teams move workloads securely.
@devartsoftware.bsky.social🐘 What is PostgreSQL? Features, uses, and benefits
See where PostgreSQL shines and what to watch out for as your data grows.
📖 Full guide: cutt.ly/9ym2nGSd
⚡ Write, debug, and profile SQL with AI in #dbForgeStudio for #PostgreSQL: cutt.ly/zym2mwlF
@svenhennessen.bsky.socialDer Speicherverbrauch unserer ASP.NET Core 10 Services in einem Projekt stieg täglich an.
Die Ursache: Ein Bug in der runtime.
Die Detektivarbeit, von den Metriken bis zur Repro, habe ich im Blog aufgeschrieben: vensas.de/de/blog/dotn...
@yellowduck.beMeet TIN: the mind-blowing new full-text search extension for Postgres that outperforms its competitors by handling 25x more queries per second.
#announcement #database #postgresql #reading-list