@spiezmaestro

"Under the hood, Postgresus uses pg_dump for creating backups“

So a hard no, if you really want backups.
Or if you want to do ddl (or e.g. refresh matview non-concurrently) while "backups" run.

#postgresql

This is a tool, that I will definitely test out: Postgresus. Looks very promising to improve my backup setup of PostgreSQL databases.

https://postgresus.com

#Postgresus #PostgreSQL #Homelab #Selfhosting

Somebody said @pixelfed should drop #postgreSQL support: https://github.com/pixelfed/pixelfed/issues/5496 After stumpling upon https://github.com/pixelfed/pixelfed/issues/6381 I think this is true.

#pgaiquery v0.1.0 — First stable release brings multi-model #AI directly into #PostgreSQL #opensource #database #SQL

🤖 Generate SQL from natural language queries right inside Postgres: `SELECT generate_query('list customers who have not placed an order in the last 90 days')`

📊 AI-interpreted EXPLAIN ANALYZE translates query performance data into plain language explanations

⚡ Automated index and rewrite recommendations help optimize database queries without manual analysis

🧵 👇

🔍 Schema-aware query intelligence through secure introspection understands your database structure for accurate query generation

🔌 Multi-model flexibility: supports #OpenAI, #Anthropic, #Gemini, #OpenRouter compatible APIs, and fully local inference via #Ollama

🖥️ Native support for Linux and macOS, compatible with #PostgreSQL 14 and newer versions

🛠️ Keeps your entire AI-powered SQL workflow inside Postgres — no external tools required

Self-Hosting a Bluesky Personal Data Server on Ubuntu VPS #bluesky #docker #grafana #installguide #nginx #postgresql #selfhosting #selfhosted #telegram #ubuntu #vpsguide #Cloud #Guides #VPS

Self-Hosting a Bluesky Persona...

Are you a DBA, developer, or decision maker involved with PostgreSQL? Then you should be attending PgDay Dallas! We have 3 tracks packed with information and education!

https://pgdaydallas.sched.com/registration

#PostgreSQL #postgres #conference

Indexing 100M vectors in 20 minutes on PostgreSQL with 12GB RAM

Link: https://blog.vectorchord.ai/how-we-made-100m-vector-indexing-in-20-minutes-possible-on-postgresql
Discussion: https://news.ycombinator.com/item?id=46195068

#postgresql

Indexing 100M vectors in 20 minutes on PostgreSQL with 12GB RAM

https://blog.vectorchord.ai/how-we-made-100m-vector-indexing-in-20-minutes-possible-on-postgresql

#ai #postgresql

🚀 Install and Run Self-hosted #Mattermost Instance on Linux #VPS This article provides a comprehensive guide to install and run self-hosted Mattermost instance on Linux VPS (Ubuntu/Debian). This guide will set up Mattermost with #PostgreSQL and #NGINX as a reverse proxy with HTTPS.
What is Mattermost?
Mattermost is a self-hosted, open-source collaboration platform ...
Continued 👉 https://blog.radwebhosting.com/install-and-run-self-hosted-mattermost-instance-on-linux-vps/?utm_source=mastodon&utm_medium=social&utm_campaign=mastodon.raddemo.host #unifiedcommunications #opensource #selfhosting #reverseproxy #letsencrypt #selfhosted

PG_EXPECTO: Анализ влияния размера shared_buffers на производительность СУБД PostgreSQL

Производительность СУБД — ключевой фактор , однако спонтанные проверки часто искажают реальную картину. PG_EXPECTO — это не просто набор скриптов, а чёткая методология, превращающая анализ PostgreSQL из хаотичного поиска проблем в структурированный , воспроизводимый эксперимент . Задача Используя классическую задачу о влиянии значения параметра shared_buffers на производительность СУБД, подготовить и протестировать общую методологию проведения экспериментов по анализу производительности СУБД PostgerSQL c использованием нейросети для анализа статистических данных, собранных комплексом pg_expecto в ходе нагрузочного тестирования.

https://habr.com/ru/articles/976344/

#postgresql #postgresql_performance #статистический_анализ #нагрузочное_тестирование #нейросеть #deepseek #vmstat #iostat #сезон_ии_в_разработке

Mozilla is hiring Staff Full Stack Engineer, AI

🔧 #c #cplusplus #javascript #rust #css #html #mysql #postgresql #sql
🌎 Remote; United States
⏰ Full-time
🏢 Mozilla

Job details https://jobsfordevelopers.com/jobs/staff-full-stack-engineer-ai-at-mozilla-org-aug-11-2025-cc4ab6?utm_source=mastodon.world&utm_medium=social&utm_campaign=posting
#jobalert #jobsearch #hiring

🎉 Registration for P2D2 2026 is officially OPEN! Don’t miss your chance to join the PostgreSQL community in Prague for talks, workshops, and networking. Secure your spot today and be part of an unforgettable event! 🚀

👉Get your tickets here: https://registrace.p2d2.cz/

#P2D2 #PostgreSQL #TechEvents

Mumpung agak senggang, kayaknya tiba waktunya pindahkan #postgresql nya #mastodon ini ke server yang lebih lowong.

Sysdig is hiring Software Engineer

🔧 #golang #api #kubernetes #postgresql #redis
🌎 Flexible; Italy
⏰ Full-time
🏢 Sysdig

Job details https://jobsfordevelopers.com/jobs/software-engineer-at-sysdig-com-oct-23-2023-5fd967?utm_source=mastodon.world&utm_medium=social&utm_campaign=posting
#jobalert #jobsearch #hiring

Currently completely overhauling my database model to use transactions so I can take advantage of row level security. Grumble, grumble. #SQL #RLS #PostgreSQL

There is a nice webinar coming tomorrow on #IvorySQL 5 release, an open source project to offer smooth transition to #PostgreSQL

I'll share on the specific challenges for European private organizations and public sector.

Early 8am for many Europeans, for one hour:

https://www.eventbrite.ca/e/oracle-to-postgresql-migration-technical-webinar-tickets-1976058448012

In our latest video, Solution Engineer Paul Rothrock demonstrates how pgEdge's Zero Downtime Add Node feature within Spock enables seamless cluster scaling and major version upgrades—without any service interruption.

Scripts to automate this process are available here: https://github.com/pgEdge/spock/tree/main/samples/Z0DAN

Check it out: 👉 https://www.pgedge.com/video/new-feature-highlight-zero-downtime-add-node

All pgEdge software is 100% open source under the PostgreSQL license.

#developers #programming #database #data #tech #technology #opensource #postgresql #postgres

#PostgreSQL and #NUMA: Performance Tuning Guide https://stormatics.tech/blogs/numa-linux-and-postgresql-before-libnuma-support

🎙️ New Talking Postgres podcast Ep34 is out!

Postgres committer & major contributor @melanieplageman of Microsoft joined to dig into what developers & the community will get out of @pgconfdev

This was lively, fun, informal. I hope you enjoy listening to Melanie and me banter. And while Melanie never wanted to be a conference organizer, she is on the organizing team & chairs the program committee for PGConf.dev—and had a lot to share about how things are changing, and what you can get out of the event. Also: in 2026 Postgres will turn 30!

Deadline soon: the PGConf.dev CFP will close on Jan 16.

Listen wherever you get your podcasts. (And feedback, recommendations, shout-outs, boosts all welcome)

#PostgreSQL #Postgres #PGConfdev #conference #OpenSource #developer

🎧 https://talkingpostgres.com/episodes/what-postgres-developers-can-expect-from-pgconf-dev-with-melanie-plageman
📺 https://www.youtube.com/watch?v=wHs10_qAtr0&list=PLixnExCn6lRrb_wV1yV9thFI1r7DOPhER