alvherre, 3 months ago to postgres

After a looong review process I have pushed a patch from Dilip Kumar and Andrey Borodin that vastly improves the overall #Postgres performance under certain conditions (high pressure, lotsa transactions). More details in the commit message:

https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=53c2a97a92665be6bd7d70bd62ae6158fe4db96e

This has been in the works for four years.

#floss

hunleyd, 3 months ago to postgres

Fun with #Postgres Looped Functions and Linear Progressions https://www.crunchydata.com/blog/fun-with-postgres-looped-functions-and-linear-progressions

jakobmiksch, 3 months ago to postgres German

I always have to look up again how to start a basic #PostGIS database with #docker. That’s why I write it down:

https://gist.github.com/JakobMiksch/696379464ba29dc459a8fdbe001ba15a

#postgres #postgresql #gischat

hyde, 3 months ago to postgres

if you use #postgres with the "PreferQueryMode=SIMPLE" enabled, you should patch asap : https://nvd.nist.gov/vuln/detail/CVE-2024-1597

#infosec #security #postgresql

niconoe, 3 months ago to python

Good afternoon!

I'll have some availability (2 days/week) starting in April. Don't hesitate to contact me for your projects!

Keywords: #biodiversity #biodiversityinformatics #fullstack #python #django #vue #svelte #typescript #postgres #postgis ...

hunleyd, 3 months ago to postgres

#Postgres + Citus + Partman, Your #IoT Database https://www.crunchydata.com/blog/postgres-citus-partman-your-iot-database

hunleyd, 3 months ago to postgres

#Postgres FM | Companion databases https://share.transistor.fm/s/72c91d81 #podcast

hunleyd, 3 months ago to postgres

Designing Your #Postgres Database for Multi-tenancy https://www.crunchydata.com/blog/designing-your-postgres-database-for-multi-tenancy

pg_at_msft, 3 months ago to PostgreSQL

Hello 👋 We'll be sharing updates from the #PostgreSQL team 🐘 at Microsoft here, including our open source contributions to the Postgres database core—plus our work on the Azure Database for PostgreSQL managed service. And more!

✅ If you missed this 📝 blog post on what's new with Postgres at Microsoft by @clairegiordano, it's still quite current & gives a good overview

#Postgres #OpenSource #Microsoft #Azure #PosetteConf #AzureDBPostgres https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/what-s-new-with-postgres-at-microsoft-august-2023/ba-p/3914506

vyruss, 3 months ago to PostgreSQL

👋 Valued contacts in IT and specifically in the #PostgreSQL / #Database community: I'd love it if you could reach out to me with insights or stories to tell regarding 🧠 mental health in the #IT #workplace. Many thanks in advance 🙏

#databases #mentalHealth #informationTechnology #openSource #postgres #wellness #mentalWellness #stigma #neurodiversity

hunleyd, 3 months ago to postgres

Combining Queries into Ctes https://momjian.us/main/blogs/pgblog/2023.html#November_13_2023 #postgres

hazz223, 3 months ago to tech

Can anyone recommend a good, lightweight, Postgres SQL editor for Mac?
I love DBeaver, but I'm finding it slow and cumbersome for my relatively simplistic needs.

#DBeaver #SQL #Tech #IDE #Postgres

vyruss, 3 months ago to PostgreSQL

@fosdem 2024 was once again a great opportunity to learn about #PostgreSQL and interact with the #Postgres #community. I also had the great pleasure to meet many fellow enthusiasts at the PostgreSQL Europe booth, where I was joined by friend and comrade-in-arms @tchorix and we took the opportunity to do an impromptu book signing for "PostgreSQL 16 Administration Cookbook" which we co-authored 👉 https://packt.link/BmLOz

#conference #techbooks #fosdem #dba #databaseAdministration #sql

hunleyd, 3 months ago to postgres

Fun with #Postgres Floats, Positioning, and Sequencing https://www.crunchydata.com/blog/fun-with-postgres-floats-positioning-and-sequencing

hunleyd, 3 months ago to postgres

#Postgres FM | Blue-green deployments https://share.transistor.fm/s/2d4861ca #podcast

hunleyd, 3 months ago to postgres

PGMQ: Lightweight Message Queue on #Postgres with No Background Worker | Tembo https://tembo.io/blog/pgmq-self-regulating-queue/

clairegiordano, 4 months ago to PostgreSQL

From my #pgconfeu selfies archive, this is me and fellow PGConfEU speaker Derk van Veen of ⁦⁦Adyen

On Wed Feb 7 at 10am PST = 6pm UTC = 7pm CST, Derk will join as a guest on the #PathToCitusCon podcast which I host :)

Topic = From developer to #PostgreSQL specialist

Join us! Instructions on how/where to join the Microsoft Open Source Discord for the live recording are in the cal invite.

#podcast #Postgres #Microsoft #OpenSource #database #community

https://aka.ms/PathToCitusCon-Ep12-cal

hunleyd, 4 months ago to postgres

#Postgres FM | Data model trade-offs https://share.transistor.fm/s/758958ca #podcast

hunleyd, 4 months ago to postgres

Tuple shuffling: #Postgres CTEs for Moving and Deleting Table Data https://www.crunchydata.com/blog/tuple-shuffling-postgres-ctes-for-update-and-delete-table-data

hunleyd, 4 months ago to postgres

Application Services: Helping #Postgres Do More, Faster | Tembo https://tembo.io/blog/tembo-operator-apps/ #k8s

ruud, 4 months ago to postgres

Almost time for #FOSDEM again. I will attend Fosdem #PGDay on Friday and will be attending most of the #Postgres Devroom on Sunday and as many other talks in between.. (like I do every year 😄 )

I still don't see many #Fediverse related talks on the schedule? If you found any, please let me know.

I'm very happy that the #Mastodon team will be there so I can meet them.

Anyone else that wants to meet let me know!

hunleyd, 4 months ago to postgres

#Postgres FM | Under-indexing https://share.transistor.fm/s/b04e8d10 #podcast

hunleyd, 4 months ago to postgres

#GSoC 2024 calls for aid! And #Postgres will answer! | Pavlo pg Golub https://pashagolub.github.io/blog/2024/GSoC-2024/

rustprooflabs, 4 months ago to postgres

I don't know how many times I've said "If you'd just run Postgres on an EC2 instance, you'll get >20% better performance for 50% or less of the cost."

So glad to see a post explaining this and putting numbers to it.

"$11K bill down to a $2100"

"Queries that would take hours or timeout altogether run in seconds."

#postgres #postgresql #performance

https://medium.com/

hunleyd, 4 months ago to postgres

Deploying Crunchy #Postgres for #Kubernetes in a Multi-Zone Cluster https://www.crunchydata.com/blog/deploying-crunchy-postgres-for-kubernetes-in-a-multi-zone-cluster