4 days until PGConf.DE 2026.
We have 4 different tracks (including sponsor track) with talks.
4 days until PGConf.DE 2026.
We have 4 different tracks (including sponsor track) with talks.
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
News: PGConf.BE : Preliminary schedule, registrations open and speakers online
π 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

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.

ΠΡΠΈΠ²Π΅Ρ! Π ΡΡΠΎΠΉ ΡΡΠ°ΡΡΠ΅ ΠΌΡ, ΠΠ°Π²Π΅Π» ΠΠΎΠ±Π°Π½ΠΎΠ² β ΡΡΠ°ΡΡΠΈΠΉ ΠΈΠ½ΠΆΠ΅Π½Π΅Ρ Π² ΠΏΠ»Π°ΡΡΠΎΡΠΌΠ΅ ΠΎΡΠΏΡΠ°Π²Π»Π΅Π½ΠΈΠΉ ΠΈ ΠΠΌΠΈΡΡΠΈΠΉ Π‘ΠΈΠ΄ΠΎΡΠ΅Π½ΠΊΠΎ β ΡΡΠ°ΡΡΠΈΠΉ ΠΈΠ½ΠΆΠ΅Π½Π΅Ρ Π² Π»ΠΎΠ³ΠΈΡΡΠΈΡΠ΅ΡΠΊΠΎΠΉ ΠΏΠ»Π°ΡΡΠΎΡΠΌΠ΅ Π΄ΠΎΡΡΠ°Π²ΠΊΠΈ ΠΠ²ΠΈΡΠΎ , ΡΠ°ΡΡΠΊΠ°ΠΆΠ΅ΠΌ, ΠΊΠ°ΠΊ ΡΠ΅ΡΠΈΠ»ΠΈ ΠΏΡΠΎΠ±Π»Π΅ΠΌΡ...
Our CEO, Christophe Pettus, will be giving his talk βWhy is Postgres Terribleβ on Tuesday, May 19th at https://PGConf.dev!
"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."