It was great to see the Postgres community and SEAPUG representing at PASS this week!

Julie and I were honored to share a day with passionate folks learning about PostGIS and PostgreSQL. Plus a session about the power of extensions and how easy it's gotten to create them with pgrx.

On top of all that, I finally got to meet a few people in person! 👋 @ryanbooz @clairegiordano, Robert, Pavlo, and Christoff!

#postgis #postgres #postgresql #pgrx #passdatasummit #community

The PgConfig site now has config from Postgres 16Beta1 loaded!

8 new options, 2 removed.

https://pgconfig.rustprooflabs.com/param/change/15/16beta1

#postgres #postgresql

Ouch... If you're using bit.io for database hosting, you have less than a month to get through an unplanned database migration.

A month is a short time to go through a db migration between hosts for all but toy projects. I'd really hope a DB host getting acquired (not going under) would give a longer off ramp.

This puts a wet towel on any desire to try DataBricks... this is not "developer friendly" 🤷‍♂️

#postgres #postgresql

https://blog.bit.io/whats-next-for-bit-io-joining-databricks-ace9a40bce0d

Such an innocent looking query... I didn't expect it to do this!

One table has 500 rows, the other has 381k. Table stats are accurate. The planner still decides it will return 39M rows, roughly 20% of what a cartesian join. The screenshot is from pgMustard, plan here: https://app.pgmustard.com/#/explore/486276b3-d9e5-4bc8-a1eb-a3a23cd1caf4?highlighted=0

SELECT *
FROM store_potential_customers p
INNER JOIN osm.road_line r
ON r.route_motor
WHERE p.geom <-> r.geom < 100
;

@michristofides
#postgis #postgresql #postgres #performance