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

hunleyd, 4 months ago to postgres

#Postgres FM | Over-indexing https://share.transistor.fm/s/dd45e301 #podcast

ricmac, 4 months ago to postgres

A company called Tembo is encouraging developers to build on top of Postgres, using an ever-growing array of Postgres extensions. My latest for @TheNewStack: https://thenewstack.io/how-devs-can-use-postgres-extensions-including-for-ai-apps/ #Postgres

hunleyd, 4 months ago to postgres

#Postgres Goodies in #Ruby on Rails 7.1 https://www.crunchydata.com/blog/postgres-goodies-in-ruby-on-rails-7-1

milan, 4 months ago to postgres

has anyone first hand experience with using live #zfs snapshots of #postgres? what i read seems to confirm that postgres should just start right up like it was recovering from a crash. what i worry about a bit is a quite large and high traffic database thats currently being handled by pgbackrest (which even for diff backups is quite slow).
currently considering something like ZnapZend :think_bread:
background being two dead ssd raids after reboot in a row.

hunleyd, 4 months ago to postgres

#Postgres FM | Query hints https://share.transistor.fm/s/792af68e #podcast

schenklklopfer, 4 months ago to postgres German

Aaaha, #Postgres 12 ist also nicht kompatibel zu Postgres 13. Und upgraden kann man wohl nicht...

Ich werf das Ding jetzt weg und machs komplett neu -.-

The data directory was initialized by PostgreSQL version 12, which is not compatible with this version 13.13

hunleyd, 5 months ago to postgres

Working with Money in #Postgres https://www.crunchydata.com/blog/working-with-money-in-postgres

fluepke, 5 months ago to linux

What is the fastest way to walk a filesystem on #Linux?

I am looking to replace locate by enumerating my home directory into a #postgres databases. In a PoC, searching was extremely fast, but initial ingestion and updates are costly operations.

Maybe there's a way to speed things up? Maybe I should read the block device directly with a userspace implementation? Sounds tricky, potentially dangerous and reduces compatibility. Mhmm 🤔

chrastecky, 5 months ago to lemmy

I've written a plug&play docker image that adds support for webhooks to #Lemmy.

It's written in #php (#Symfony) and uses the #SymfonyMessenger component and #Postgres listen/notify feature.

See the source code (and README) at https://github.com/RikudouSage/LemmyWebhook

hunleyd, 5 months ago to postgres

#Postgres FM | Stop and start Postgres faster https://share.transistor.fm/s/d0f61c12 #podcast

hunleyd, 5 months ago to postgres

Introducing pgroll: zero-downtime, reversible, schema migrations for #Postgres https://xata.io/blog/pgroll-schema-migrations-postgres

hunleyd, 5 months ago to postgres

Version History and Lifecycle Policies for #Postgres Tables | Tembo https://tembo.io/blog/table-version-history/

hunleyd, 5 months ago to postgres

pg_bm25: Elastic-Quality Full Text Search Inside #Postgres - ParadeDB https://docs.paradedb.com/blog/introducing_bm25

hunleyd, 5 months ago to postgres

#Oracle Supports #Postgres https://momjian.us/main/blogs/pgblog/2023.html#September_29_2023

jmcastagnetto, 5 months ago to postgres

"#Postgres pioneer promises to upend the #database once more" (The Register)

https://www.theregister.com/2023/12/26/michael_stonebraker_feature/

#OpenSource

hunleyd, 5 months ago to postgres

Anatomy of a #Postgres extension written in Rust: pgmq | Tembo https://tembo.io/blog/postgres-extension-in-rust-pgmq/

hunleyd, 5 months ago to postgres

TIL - When was my #Postgres cluster initialized ? https://kmoppel.github.io/2023-09-28-til-when-was-my-postgres-cluster-initialized/

hunleyd, 5 months ago to postgres

My #Postgres Story: Internationalization https://obartunov.livejournal.com/211100.html

hunleyd, 5 months ago to postgres

#Postgres FM | Backups https://share.transistor.fm/s/c3804ab2 #podcast

hunleyd, 5 months ago to postgres

How to write high-performance SQL for your #Postgres database - Stack Overflow https://stackoverflow.blog/2023/09/28/how-to-write-high-performance-sql-for-your-postgres-database/ #podcast

dgapitts, 5 months ago to tech

Just joined mastodon, giving up on X. My interests are #tech (#postgres #opensource) and #arts (#singing #drawing #watercolors)

ferretdb, 5 months ago to postgres

FerretDB enables you to run MongoDB workloads on #Postgres and #SQLite.

Since Neon maintains 100% compatibility with any application that uses the official Postgres release, that makes #Neon an excellent option to consider as the database backend for FerretDB.

We wrote a blog post on this. Check it out -->
https://buff.ly/4anvTLv

—

FerretDB is a truly #opensource alternative to MongoDB built on #Postgres