4 days until PGConf.DE 2026.

We have 4 different tracks (including sponsor track) with talks.

https://2026.pgconf.de/

#PGConfDE #Essen #PostgreSQL

PGConf.DE 2026

A 2-day, 3-track PostgreSQL conference in Essen, Germany.

random_page_cost has been 4.0 since 2002. Should you lower it on SSDs? PostgreSQL committer Tomas Vondra (Microsoft) digs in.

Register for updates to POSETTE: An Event for Postgres 2026 Livestream 1 on Tue 16 Jun & attend Tomas's talk https://posetteconf.com/2026/talks/random_page_cost-in-postgres-why-the-default-is-4-0-and-should-you-lower-it/

#PosetteConf #PostgreSQL #Postgres #Database #Community #OpenSource #Microsoft

How to Deploy #Forem on Rocky Linux #VPS This article provides a guide detailing how to deploy Forem on Rocky Linux VPS.
What is Forem?
Forem is a robust, open-source platform for building communities like DEV.to. Deploying it on Rocky Linux involves setting up dependencies like PostgreSQL, ...
Continued πŸ‘‰ https://blog.radwebhosting.com/deploy-forem-on-rocky-linux-vps/?utm_source=mastodon&utm_medium=social&utm_campaign=mastodon.raddemo.host #rockylinux #selfhosting #opensource #redis #rubyonrails #rubygems #letsencrypt #sidekiq #reverseproxy #forumsoftware #elasticsearch #forum #postgresql #selfhosted
PGConf.BE : Preliminary schedule, registrations open and speakers online

[PGConf.BE 2026](https://pgconf.be/) will be held in Haasrode, Leuven, about 25km from Brussels. The conference will take place on May 5th, …

PostgreSQL News

πŸš€ How to Deploy #Funkwhale on #Debian #VPS

This article provides a guide demonstrating how to deploy Funkwhale on Debian VPS.
What is Funkwhale?
Funkwhale is a self-hosted, federated audio platform for streaming and sharing music & podcasts. It uses #ActivityPub so libraries can follow/feature content across instances (like Mastodon), and it offers a web UI plus ...
Continued πŸ‘‰ https://blog.radwebhosting.com/deploy-funkwhale-on-debian-vps/?utm_source=mastodon&utm_medium=social&utm_campaign=mastodon.raddemo.host #selfhosted #certbot #selfhosting #postgresql #opensource #letsencrypt #redis #python

AnatomΓ­a de una consulta SQL: Un Viaje a TravΓ©s del Procesamiento de Consultas de PostgreSQL by JesΓΊs Espino is a new release on Leanpub!

Link: https://leanpub.com/anatomia-de-una-consulta-sql

#books #ebooks #newreleases #leanpublishing #selfpublishing #postgresql #databases

AnatomΓ­a de una consulta SQL

Un recorrido guiado por los mecanismos internos del procesamiento de consultas de PostgreSQL. Aprende cΓ³mo se analiza sintΓ‘cticamente, se valida semΓ‘nticamente, se optimiza y se ejecuta una consulta SQL, siguiendo una ΓΊnica consulta a travΓ©s de cada etapa del pipeline, desde la conexiΓ³n hasta los resultados.

ЀитнСс ΠΏΠ»Π°Π½ для PostgreSQL своими Ρ€ΡƒΠΊΠ°ΠΌΠΈ: ΠΊΠ°ΠΊ ΠΏΠΎΡ…ΡƒΠ΄Π΅Ρ‚ΡŒ, ΠΊΠΎΠ³Π΄Π° Π½Π΅Ρ‚ доступа ΠΊ pg_repack ΠΈ pgcompacttable

ΠŸΡ€ΠΈΠ²Π΅Ρ‚! Π’ этой ΡΡ‚Π°Ρ‚ΡŒΠ΅ ΠΌΡ‹, ПавСл Π›ΠΎΠ±Π°Π½ΠΎΠ² β€” ΡΡ‚Π°Ρ€ΡˆΠΈΠΉ ΠΈΠ½ΠΆΠ΅Π½Π΅Ρ€ Π² ΠΏΠ»Π°Ρ‚Ρ„ΠΎΡ€ΠΌΠ΅ ΠΎΡ‚ΠΏΡ€Π°Π²Π»Π΅Π½ΠΈΠΉ ΠΈ Π”ΠΌΠΈΡ‚Ρ€ΠΈΠΉ Π‘ΠΈΠ΄ΠΎΡ€Π΅Π½ΠΊΠΎ β€” ΡΡ‚Π°Ρ€ΡˆΠΈΠΉ ΠΈΠ½ΠΆΠ΅Π½Π΅Ρ€ Π² логистичСской ΠΏΠ»Π°Ρ‚Ρ„ΠΎΡ€ΠΌΠ΅ доставки Авито , расскаТСм, ΠΊΠ°ΠΊ Ρ€Π΅ΡˆΠΈΠ»ΠΈ ΠΏΡ€ΠΎΠ±Π»Π΅ΠΌΡƒ раздувания Ρ€Π°Π·ΠΌΠ΅Ρ€Π° Π΄Π°Π½Π½Ρ‹Ρ… Π² Ρ…Ρ€Π°Π½ΠΈΠ»ΠΈΡ‰Π΅ Π±Π΅Π· прСрывания Ρ€Π°Π±ΠΎΡ‚Ρ‹ сСрвиса , сохранив Π»ΠΎΡΠ»ΡŒΠ½ΠΎΡΡ‚ΡŒ ΠΏΠΎΠ»ΡŒΠ·ΠΎΠ²Π°Ρ‚Π΅Π»Π΅ΠΉ ΠΈ дСньги ΠΊΠΎΠΌΠΏΠ°Π½ΠΈΠΈ. Π­Ρ‚Π° история ΠΎ Ρ‚ΠΎΠΌ, ΠΊΠ°ΠΊ ΠΌΡ‹ ΠΏΡ€ΠΈΠ΄ΡƒΠΌΠ°Π»ΠΈ ΠΈ Ρ€Π΅Π°Π»ΠΈΠ·ΠΎΠ²Π°Π»ΠΈ свой собствСнный ΠΌΠ΅Ρ‚ΠΎΠ΄, ΠΊΠΎΠ³Π΄Π° Π½ΠΈΠΊΠ°ΠΊΠΈΠ΅ Π΄Ρ€ΡƒΠ³ΠΈΠ΅ сторонниС инструмСнты Π½Π΅ позволяли ΡΠΎΡ…Ρ€Π°Π½ΡΡ‚ΡŒ Ρ€Π°Π±ΠΎΡ‚ΠΎΡΠΏΠΎΡΠΎΠ±Π½ΠΎΡΡ‚ΡŒ сСрвиса ΠΈ Π³Π°Ρ€Π°Π½Ρ‚ΠΈΡ€ΠΎΠ²Π°Ρ‚ΡŒ Π½Π°Π΄Ρ‘ΠΆΠ½ΠΎΡΡ‚ΡŒ. Π•Π³ΠΎ ΠΌΠΎΠΆΠ½ΠΎ ΠΏΡ€ΠΈΠΌΠ΅Π½ΡΡ‚ΡŒ Π²ΠΎ всём ΠΌΠΈΡ€Π΅, Π³Π΄Π΅ ΠΈΡΠΏΠΎΠ»ΡŒΠ·ΡƒΡŽΡ‚ΡΡ ΠΏΠ»Π°Ρ‚Ρ„ΠΎΡ€ΠΌΡ‹ Π½Π° Π±Π°Π·Π΅ PostgreSQL.

https://habr.com/ru/companies/avito/articles/1023610/

#postgresql #Π±Π°Π·Ρ‹_Π΄Π°Π½Π½Ρ‹Ρ… #sql #bloat

ЀитнСс ΠΏΠ»Π°Π½ для PostgreSQL своими Ρ€ΡƒΠΊΠ°ΠΌΠΈ: ΠΊΠ°ΠΊ ΠΏΠΎΡ…ΡƒΠ΄Π΅Ρ‚ΡŒ, ΠΊΠΎΠ³Π΄Π° Π½Π΅Ρ‚ доступа ΠΊ pg_repack ΠΈ pgcompacttable

ΠŸΡ€ΠΈΠ²Π΅Ρ‚! Π’ этой ΡΡ‚Π°Ρ‚ΡŒΠ΅ ΠΌΡ‹, ПавСл Π›ΠΎΠ±Π°Π½ΠΎΠ² β€” ΡΡ‚Π°Ρ€ΡˆΠΈΠΉ ΠΈΠ½ΠΆΠ΅Π½Π΅Ρ€ Π² ΠΏΠ»Π°Ρ‚Ρ„ΠΎΡ€ΠΌΠ΅ ΠΎΡ‚ΠΏΡ€Π°Π²Π»Π΅Π½ΠΈΠΉ ΠΈ Π”ΠΌΠΈΡ‚Ρ€ΠΈΠΉ Π‘ΠΈΠ΄ΠΎΡ€Π΅Π½ΠΊΠΎ β€” ΡΡ‚Π°Ρ€ΡˆΠΈΠΉ ΠΈΠ½ΠΆΠ΅Π½Π΅Ρ€ Π² логистичСской ΠΏΠ»Π°Ρ‚Ρ„ΠΎΡ€ΠΌΠ΅ доставки Авито , расскаТСм, ΠΊΠ°ΠΊ Ρ€Π΅ΡˆΠΈΠ»ΠΈ ΠΏΡ€ΠΎΠ±Π»Π΅ΠΌΡƒ...

Π₯Π°Π±Ρ€

Ming Ying: ParadeDB is Officially on Railway

https://postgr.es/p/8H0

#postgresql

ParadeDB is Officially on Railway

Deploy ParadeDB on Railway with one click. Full-text search, vector search, and hybrid search over Postgres β€” now available on your favorite cloud platform.

Our CEO, Christophe Pettus, will be giving his talk β€œWhy is Postgres Terrible” on Tuesday, May 19th at https://PGConf.dev!

https://2026.pgconf.dev/session/658

#PostgreSQL #postgres #conference

"PostgreSQL User Management: Create Users and Grant Privileges"

"Step-by-step instructions for creating PostgreSQL users (roles), setting passwords, and granting or revoking privileges on databases, schemas, and tables."

https://linuxize.com/post/postgresql-user-management/

#Linux #PostgreSQL

PostgreSQL User Management: Create Users and Grant Privileges

Step-by-step instructions for creating PostgreSQL users (roles), setting passwords, and granting or revoking privileges on databases, schemas, and tables.

Linuxize