SAVE THE DATE : vous souhaitez mettre à jour vos connaissances sur #PostgreSQL ?

📣 Les journées Ateliers et Conférences de la #pgsession19 auront lieu les **12 et 13 janvier 2027** à Paris =>
https://blog.dalibo.com/2026/06/11/pgsession_19.html

#SGBD #DBA #opensource
#conférences #workshops

Alt...

Visuel de promo de la PGSession 19, prévue en janvier 2027

Richard Yen: PGDay Boston 2026

https://postgr.es/p/9lF

#postgresql

Christophe Pettus: All Your GUCs in a Row: the debug_* family

https://postgr.es/p/9lE

#postgresql

Richard Yen: PGDay Boston 2026

https://postgr.es/p/9lD

#postgresql

Christophe Pettus: All Your GUCs in a Row: deadlock_timeout

https://postgr.es/p/9lC

#postgresql

now I track my GPS position using my browser and use #h3 and #postgis to create a traffic density heatmap, with very few code thanks to #httpg and #postgresql https://github.com/docteurklein/httpg/blob/main/gps/sql/view.sql

Alt...

create or replace view heatmap (hex, weight) as select ST_CoverageClean(h3_cell_to_boundary_geometry(location @ 10)) over (), count(*) from ping group by location @ 10 order by 2;

Alt...

a map showing a running segment with coloration to show traffic density

Christoph Berg: PGConf.dev 2026 in Vancouver

https://postgr.es/p/9lB

#postgresql

Cornelia Biacsics: Contributions for week 22, 2026

https://postgr.es/p/9lA

#postgresql

Stefanie Janine: My Three Top PostgeSQL 19 Features

https://postgr.es/p/9lz

#postgresql

Christophe Pettus: All Your GUCs in a Row: DateStyle

https://postgr.es/p/9ly

#postgresql

Christophe Pettus: How the Other Half Counts

https://postgr.es/p/9lx

#postgresql

Vibhor Kumar: pg_background 2.0: Run SQL in the Background, Now Cleaner, Safer, and Ready for PostgreSQL 19

https://postgr.es/p/9lw

#postgresql

Stefanie Janine Stölting: pgsql_tweaks Version 1.0.3 Released

https://postgr.es/p/9lv

#postgresql

Christophe Pettus: All Your GUCs in a Row: data_sync_retry

https://postgr.es/p/9lu

#postgresql

Is this possible using PostGIS?

It feels like it should be an obvious use-case, but the right approach isn't clear to me after reading the docs.

Imagine having one set of paths (actually bike rides) and another set of segments (parts of rides where I time myself).

Instead of giving my money and data to abusive companies like Strava, I want to match my rides against the segments to track my best times as well as progression.

Thus, I need to efficiently match subsegments of the rides to the segment database.

What is the most efficient way to leverage PostGIS to do this? If I can make this work, I want to turn this into a Fediverse service.

#postgres #postgresql #postgis

Christophe Pettus: All Your GUCs in a Row: data_directory_mode

https://postgr.es/p/9ls

#postgresql

Andrew Atkinson: Beta Testing PostgreSQL With Docker

https://postgr.es/p/9lr

#postgresql

Christophe Pettus: All Your GUCs in a Row: data_directory

https://postgr.es/p/9lq

#postgresql

Mark Wong: Acknowledged Individuals in the PostgreSQL Release Notes: 2026 Edition

https://postgr.es/p/9lp

#postgresql

Lætitia AVROT: A Reviewer Was Born

https://postgr.es/p/9lo

#postgresql

Shaun Thomas: Looking Forward to Postgres 19: Query Hints

https://postgr.es/p/9ln

#postgresql

Floor Drees: How to test PostgreSQL 19 beta in your Kubernetes cluster

https://postgr.es/p/9li

#postgresql

Christophe Pettus: All Your GUCs in a Row: data_checksums

https://postgr.es/p/9lc

#postgresql

warda bibi: File Descriptors: The OS Limit That Takes Down PostgreSQL

https://postgr.es/p/9lb

#postgresql

Stefan Fercot: Does pgBackRest work with pg_tde?

https://postgr.es/p/9la

#postgresql

Cette semaine se tiendront les journées ateliers et conférences annuelles du #PGDayFr à Toulouse 🐘Retrouvez moi aux stands avec l'équipe @dalibo pour découvrir nos nouvelles offres et nouveaux produits open-source ! #postgres #postgresql

Le #pgday France, c'était hier à Toulouse ! Toujours un moment convivial.

Notre équipe a assuré la tenue du stand et l'animation des ateliers sur le développement d'une extension en #Rust, et l'alliance PostgreSQL Anonymizer + #kubernetes .

Merci à nos collègues 💐

#anonymisation #PostgreSQL
@postgresqlfr

Alt...

Stand Dalibo au PG DayFrance 2026

Christophe Pettus: All Your GUCs in a Row: cursor_tuple_fraction

https://postgr.es/p/9l9

#postgresql

David Wheeler: pg_clickhouse 0.3.1: Now With More C

https://postgr.es/p/9l8

#postgresql

Hans-Juergen Schoenig: Handling graphs with SQL/PGQ in PostgreSQL

https://postgr.es/p/9l7

#postgresql

Radim Marek: pg_stat_statements: everything it can't

https://postgr.es/p/9l6

#postgresql

Laurenz Albe: When is a function leakproof?

https://postgr.es/p/9l5

#postgresql

Christophe Pettus: All Your GUCs in a Row: createrole_self_grant

https://postgr.es/p/9l4

#postgresql

Radim Marek: pg_stat_statements: everything it tells you

https://postgr.es/p/9l3

#postgresql

Robert Haas: Hacking Workshop for June/July 2026

https://postgr.es/p/9l2

#postgresql

Christophe Pettus: Managed Postgres, Examined: Azure Database for PostgreSQL Flexible Server

https://postgr.es/p/9l1

#postgresql

semab tariq: The Night Our Tables Wouldn’t Stop Growing

https://postgr.es/p/9l0

#postgresql

Christophe Pettus: All Your GUCs in a Row: cpu_index_tuple_cost, cpu_operator_cost, and cpu_tuple_cost

https://postgr.es/p/9k_

#postgresql

Shaun Thomas: Looking Forward to Postgres 19: The New REPACK Command

https://postgr.es/p/9kY

#postgresql

Christophe Pettus: SQL/PGQ in PostgreSQL 19: Graph Queries Without the Graph Database

https://postgr.es/p/9kW

#postgresql

Cornelia Biacsics: Contributions for week 21, 2026

https://postgr.es/p/9kV

#postgresql

Wim Bertels: PGConf.be 2026

https://postgr.es/p/9kU

#postgresql

Publication de PostgreSQL 18.4 : https://www.loxodata.com/post/postgresql-18-4/
#PostgreSQL

Christophe Pettus: All Your GUCs in a Row: constraint_exclusion

https://postgr.es/p/9kT

#postgresql

Christophe Pettus: Patch PgBouncer Today

https://postgr.es/p/9ju

#postgresql

RELEASE : annonce de fin de vie de la v.14, correctifs de sécurité, améliorations et conseils pour mettre à jour votre #SGBD… Voici notre traduction de l'annonce communautaire =>
https://blog.dalibo.com/2026/05/15/postgresql_release_18.4.html

#PostgreSQL #opensource #DBA #update

Alt...

capture

#pgbackrest is dead. What next?

https://mydbanotebook.org/posts/pgbackrest-is-dead.-now-what/

#PostgreSQL