📢 In just 2 days we will be presenting “What’s New in Postgres 19” with Christphe Pettus! RSVP today! 🐘
@bayareapostgres.bsky.social
@bayareapostgres.bsky.social📢 In just 2 days we will be presenting “What’s New in Postgres 19” with Christphe Pettus! RSVP today! 🐘
@pgsummitus.bsky.socialThank you Percona for your Silver sponsorship! Your generous support makes community events like Postgres Summit US possible!
@explainmeasured.comUNION on two halves of a 2M-row table that can't overlap: 13.6 s.
UNION ALL on the same halves: 0.68 s.
Nothing tells PostgreSQL the halves are disjoint, so UNION deduplicated 2M emails to be sure. One word.
@cybertec-official.bsky.socialStill time to register! On 5 November, CYBERTEC & DESIC go live on leaving Oracle without leaving your security standards behind, at 12:00 CET, conducted in Spanish.
https://www.cybertec-postgresql.com/en/webinar-from-oracle-to-postgresql/
@qscaram.bsky.socialPostgreSQL 19 è alla quarta beta e l'obiettivo è farlo uscire entro fine ottobre. Scommetto che fra un anno in produzione lo avranno in pochi. Ci sono le estensioni da aggiornare. E c'è sempre il fornitore che certifica solo la versione di tre anni fa. #PostgreSQL
@opsmatters.comThe latest update for #Speedscale includes "Holiday readiness: run your first load test with skills" and "Load Test #PostgreSQL Instantly using Production Recordings".
#DevOps #Kubernetes #Testing #API https://opsmtrs.com/3hs7riT
@maxiong.bsky.socialSpent some time tweaking the Call Nextval dialog this morning. Finally got it just the way I wanted!
@pgsummitus.bsky.socialThank you Datadog for your Gold sponsorship! Your generous support makes community events like Postgres Summit US possible!
@planet.postgresql.orgChris van Eijk: infinite recursion detected in policy: causes and fixes
@pgsummitus.bsky.socialThank you Tiger Data for your Gold sponsorship! Your generous support makes community events like Postgres Summit US possible!
@maxiong.bsky.socialTotally forgot about Sequences when adding #PostgreSQL support. Finally got that done today!
@pgexperts.bsky.socialPostgreSQL 19 RC 1 is scheduled for October 15th, with GA planned for October 29th. Eleven items are still open on the wiki.
@pgsummitus.bsky.socialThank you Clickhouse for your Gold sponsorship! Your generous support makes community events like Postgres Summit US possible!
@bayareapostgres.bsky.social📢 It’s 3 days away! Join us on Tuesday, October 13th for “What’s New in Postgres 19” with Christophe Pettus! RSVP today! 🐘
@adhisimon.kodesumber.com.ap.brid.gySiap-siap pindahin #postgresql instance ini ke mesin yang lebih lowong.
@radwebhosting.comHow to Install #Directus on #AlmaLinux #VPS
Here's a step-by-step guide detailing how to install Directus on AlmaLinux VPS.
What is Directus?
Directus ...
Continued 👉 #cmsapps #npm #selfhosting #postgresql #selfhosted #opensource #installguide #contentmanagement #nodejs #letsencrypt #vpsguide
@pgsummitus.bsky.socialThank you Navicat for your Gold sponsorship! Your generous support makes community events like Postgres Summit US possible!
@pgus.bsky.socialDo you love PostgreSQL? Join PgUS! Your membership will help support events and education within the PostgreSQL community!
@explainmeasured.comUUIDs often end up in text columns because an ORM or a JSON payload made it the easy path. I measured what that costs on 5M rows.
The text index came out 88% bigger and one level deeper, so every lookup reads one more page. With random v4 keys, inserts went from 47 s to 79 s.
@vyruss.orgApache Community Over Code Lakehouse day kicking off! And #PostgreSQL is here too ;)
