Skip to main content

Search

Items tagged with: postgres

Introducing Nile, #Serverless #Postgres for modern #SaaS

https://www.thenile.dev/blog/introducing-nile

Has anyone used it, has some opinion about it?
(yes, I know that serverless is a buzzword)

Introducing Nile, Serverless Postgres for modern SaaS

I am thrilled to announce Nile, a serverless Postgres database designed for modern SaaS applications.
www.thenile.dev
#Serverless #postgres #saas

I'll be speaking at #passdatasummit in a few weeks! Doing a full day pre-con on PostGIS (using OpenStreetMap of course) and a general session on Postgres extensions.

By my count, 12% of all sessions have something to do with Postgres! 🐘 Not bad for a traditionally MS conference 🤓

#postgres #postgis #gischat

https://blog.rustprooflabs.com/2023/10/pass-2023-coming-soon

See you at PASS Data Community Summit! - Blog @ RustProof Labs

blog.rustprooflabs.com
#postgis #gischat #postgres #passdatasummit

Our pgconfig tool is updated for Postgres 16! 🐘

https://pgconfig.rustprooflabs.com/

#postgres #postgresql

postgresql.conf compare

Postgres configuration file (postgresql.conf) differences across major versions starting with Postgres 9.2.
pgconfig.rustprooflabs.com
#postgresql #postgres

PgOSM Flex is ready to go with Postgres 16 and PostGIS 3.4! 🤓 🐘 🗺️

#pgosm #postgis #postgres #postgresql #openstreetmap #gischat

https://github.com/rustprooflabs/pgosm-flex/releases/tag/0.10.2

Release 0.10.2 · rustprooflabs/pgosm-flex

PgOSM Flex 0.10.2 Commit hash: f45b3f6 The commit hash from this git repo shows up with the PgOSM Flex version number in SELECT pgosm_flex_version FROM osm.pgosm_flex; If you see this version wit...
GitHub
#openstreetmap #postgis #gischat #postgresql #postgres #pgosm

Postgres 16 is OUT THERE! 🐘🎉

#postgres #postgresql

https://www.postgresql.org/about/news/postgresql-16-released-2715/

PostgreSQL 16 Released!

September 14, 2023 - The PostgreSQL Global Development Group today announced the release of PostgreSQL 16, the latest version of …
PostgreSQL News
#postgresql #postgres

Sampling Postgres data in QGIS

Let's say you have a large data source and you want to roughly see what data you have, without having to pull and render every little forest path in the world (which could take forever).

You can do this by creating a custom layer and use the `TABLESAMPLE` [1] to retrieve a subset of the data.

[1] https://www.postgresql.org/docs/current/sql-select.html#SQL-FROM

#postgres #qgis

SELECT

SELECT SELECT, TABLE, WITH — retrieve rows from a table or view Synopsis [ WITH [ RECURSIVE ] with_query [, …
PostgreSQL Documentation
#qgis #postgres

PGSQLPhriday #008 Roundup! 🤓

Great topic this month, thanks @michristofides for hosting!

https://www.pgmustard.com/blog/pgsql-phriday-008-roundup

#pgsqlphriday #postgres #postgresql

PGSQL Phriday #008 roundup and review!

A couple of weeks ago, I invited folks to blog about pg_stat_statements , as I was hosting the eighth monthly PGSQL Phriday. It was fun seeing the posts roll in last week— I’m so grateful to everyone who got involved.
Michael Christofides (pgMustard)
#postgresql #postgres #pgsqlphriday @Michael Christofides

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
#postgis #postgresql #performance #postgres @michristofides

This website uses cookies to recognize revisiting and logged in users. You accept the usage of these cookies by continue browsing this website.

⇧