hunleyd, 4 days ago to postgres

What’s new in the #Postgres 16 query planner / optimizer https://www.citusdata.com/blog/2024/02/08/whats-new-in-postgres-16-query-planner-optimizer/

paul, 6 days ago to postgres

Selfhosted instance.

I am thinking of breaking #Postgres and #ElasticSearch to a separate server instead of increasing my current VPS resources.

I'll have two servers. My main, which will run Mastodon, and another that will have Postgres and ElasticSearch on it.

Will I benefit by doing this or should I just move ElasticSearch to its own server? What is the minimum CPU/ram I can get for the second server & what should I get?

Or, other thoughts welcomed.
#MastoAdmin

hunleyd, 10 days ago to postgres

#Postgres again elected DBMS of the Year in 2023, but I'm worried | Select * from Adrien https://blog.anayrat.info/en/2024/02/05/postgres-again-elected-dbms-of-the-year-in-2023-but-im-worried/

clairegiordano, 10 days ago to PostgreSQL

I am so excited to be @PGConfdev in Vancouver & you can expect to see a lot of #PGConfdev posts from me all week this week.

📸 Seen here at the registration desk is @sqlliz with #PostgreSQL committers @melanieplageman & Tom Lane in the background

#Postgres #conference #OpenSource #database #PostgresFriends

hunleyd, 12 days ago to postgres

#Postgres.AI bot interview for PGSQL Phriday #015 - CYBERTEC https://www.cybertec-postgresql.com/en/postgres-ai-bot-interview-for-pgsql-phriday-015/

eulerto, 12 days ago to postgres

On my way to PGConf.dev 2024 #postgres

hunleyd, 15 days ago to postgres

#Postgres FM | Modern #SQL #podcast https://share.transistor.fm/s/b426eed3

hunleyd, 15 days ago to postgres

Automate vector search in #Postgres with any Hugging Face transformer | Tembo https://tembo.io/blog/sentence-transformers

hunleyd, 16 days ago to postgres

UUID in #Postgres: PgSQLPhriday #015 - Blog @ RustProof Labs https://blog.rustprooflabs.com/2024/01/postgres-uuid

hunleyd, 18 days ago to postgres

JSON and SVG from #PostGIS into Google Sheets | Crunchy Data Blog #postgres https://www.crunchydata.com/blog/json-and-svg-from-postgis-into-google-sheets

paulox, 19 days ago to ubuntu

🚀 I just published a short guide explaining how to upgrade PostgreSQL 🐘 from version 15 to 16 just after an upgrade to Ubuntu 24.04 LTS (Noble Numbat) 🦘

#Ubuntu #NobleNumbat #Noble #Numbat #LTS #PostgreSQL #Postgres #HowTo #Upgrade

Read it 👇
https://www.paulox.net/2024/05/20/upgrading-postgresql-from-version-15-to-16-on-ubuntu-24-04-noble-numbat/

hunleyd, 23 days ago to llm

Postgres.AI Bot. Towards #LLM OS for #Postgres | Postgres.AI https://postgres.ai/blog/20240127-postges-ai-bot

hunleyd, 26 days ago to postgres

#Postgres FM | Bloat #podcast https://share.transistor.fm/s/5bd92bae

hunleyd, 26 days ago to postgres

How we built our customer data warehouse all on #Postgres | Tembo https://tembo.io/blog/tembo-data-warehouse

clairegiordano, 26 days ago to PostgreSQL

Hello to those of you who went to #PGDayChicago (organized by the amazing Henrietta Dombrovskaya) here are my slides.

The conference was so much fun! 🎉🐘 I was honored to give this talk & spend time w/#PostgreSQL & #Microsoft friends

🎤 Map of Amazing Postgres Extensions You Might Not Know About 🎤

#Postgres #OpenSource #database #conference

https://speakerdeck.com/clairegiordano/map-of-amazing-postgres-extensions-you-might-not-know-about-claire-giordano-pgday-chicago-2024

marcel_jomasoft, 29 days ago to programming German

Updated PostgreSQL IPS packages for Solaris 11.4 SPARC are available
Versions 16.3, 15.7, 14.12, 13.15, 12.19

https://www.jomasoft.ch/downloads/#js-opensource

#solaris #oraclesolaris #postgres #postgresql

hunleyd, 30 days ago to postgres

I’m a #Postgres Extensions Tembonaut https://justatheory.com/2024/01/tembonaut/

frankel, 30 days ago to postgres

PeerDB Streams - Simple, Native #Postgres #ChangeDataCapture #CDC

https://blog.peerdb.io/peerdb-streams-simple-native-postgres-change-data-capture

hunleyd, 1 month ago to postgres

#Postgres FM | pgvector #podcast https://share.transistor.fm/s/0d0398b6

hunleyd, 1 month ago to postgres

One PID to Lock Them All: Finding the Source of the Lock in #Postgres | Crunchy Data Blog https://www.crunchydata.com/blog/one-pid-to-lock-them-all-finding-the-source-of-the-lock-in-postgres

hunleyd, 1 month ago to postgres

Troubleshooting #Postgres in Kubernetes | Crunchy Data Blog https://www.crunchydata.com/blog/troubleshooting-postgres-in-kubernetes

ryan, 1 month ago to web

Hey Fediverse, I'm looking for my next role as a #web engineer!

What I'm looking for:

• a collaborative, kind team
• at a company with noble goals, or that knows what problems it has to solve

I'm the Lead "Frontend" engineer who creates table indexes because "the UI is slow".

Point me to a mountain and I'll climb it.

Prior experience with #react #typescript #node #NextJS #postgres. I've dabbled with #rust for fun, and #dotnet in a past life.

Appreciate any advice or connections!

hunleyd, 1 month ago to postgres

Benchmarking #Postgres Vector Search approaches: Pgvector vs Lantern | Tembo https://tembo.io/blog/postgres-vector-search-pgvector-and-lantern/

hunleyd, 1 month ago to postgres

#Postgres password encryption without leaking credentials https://launchbylunch.com/posts/2024/Jan/16/postgres-password-encryption/

wilson, 1 month ago to golang

This weekend, I hacked together a markdown documentation generator for Postgres in Go. It should be extensible to other databases, as well as including other properties from database.

It's called SQLDoc — please check it out!

#golang #postgres #postgresql #sql

https://husin.dev/sqldoc/