#postgres — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #postgres, aggregated by home.social.
-
We’re excited to announce AWS as a Platinum Sponsor for PG Summit US!
-
pg_stats: How #Postgres Internal Stats Work https://richyen.com/postgres/2026/06/22/pg_stats_how_postgres_internal_stats_work.html
-
PG Summit US will be held at Convene in the heart of SoHo! It’s a new venue for us and we’re really excited about its convenient location and lovely facilities!
-
The PgUS Community Development Committee works hard to ensure that our community is safe and welcoming to everyone! How do we do that? Click the link below for more info!
-
Planning on attending PG Summit US? We have a discounted rate with Wyndham Garden Chinatown! Check it out and book soon, the deadline is August 28th!
-
Planning on attending PG Summit US? We have a discounted rate with Wyndham Garden Chinatown! Check it out and book soon, the deadline is August 28th!
-
Well then... Was not at all expecting #turso to also do #postgres. 🤯 Like if rewriting #sqlite alone wasn't hard enough. 🤣
https://turso.tech/blog/a-new-modern-version-of-postgres-in-rust
-
Well then... Was not at all expecting #turso to also do #postgres. 🤯 Like if rewriting #sqlite alone wasn't hard enough. 🤣
https://turso.tech/blog/a-new-modern-version-of-postgres-in-rust
-
Well then... Was not at all expecting #turso to also do #postgres. 🤯 Like if rewriting #sqlite alone wasn't hard enough. 🤣
https://turso.tech/blog/a-new-modern-version-of-postgres-in-rust
-
Well then... Was not at all expecting #turso to also do #postgres. 🤯 Like if rewriting #sqlite alone wasn't hard enough. 🤣
https://turso.tech/blog/a-new-modern-version-of-postgres-in-rust
-
Well then... Was not at all expecting #turso to also do #postgres. 🤯 Like if rewriting #sqlite alone wasn't hard enough. 🤣
https://turso.tech/blog/a-new-modern-version-of-postgres-in-rust
-
SSB — «мы стояли на „плоскости“»
SSB — «мы стояли на „плоскости“» Предлагаемый текст представляет опыт ознакомления автора с тестом SSB в свете обычных прикладных вопросов BI‑проекта умеренного размаха. Автор пытается бросить пытливый взгляд на спектр перспективных возможностей, обеспечиваемых доступностью и масштабируемостью теста SSB.
https://habr.com/ru/articles/1060442/
#SSB #Postgres #ClickHouse #Sizing #MDX #Flat #Star #BI #DWH #КХД
-
SSB — «мы стояли на „плоскости“»
SSB — «мы стояли на „плоскости“» Предлагаемый текст представляет опыт ознакомления автора с тестом SSB в свете обычных прикладных вопросов BI‑проекта умеренного размаха. Автор пытается бросить пытливый взгляд на спектр перспективных возможностей, обеспечиваемых доступностью и масштабируемостью теста SSB.
https://habr.com/ru/articles/1060442/
#SSB #Postgres #ClickHouse #Sizing #MDX #Flat #Star #BI #DWH #КХД
-
SSB — «мы стояли на „плоскости“»
SSB — «мы стояли на „плоскости“» Предлагаемый текст представляет опыт ознакомления автора с тестом SSB в свете обычных прикладных вопросов BI‑проекта умеренного размаха. Автор пытается бросить пытливый взгляд на спектр перспективных возможностей, обеспечиваемых доступностью и масштабируемостью теста SSB.
https://habr.com/ru/articles/1060442/
#SSB #Postgres #ClickHouse #Sizing #MDX #Flat #Star #BI #DWH #КХД
-
🎙️ New Talking Postgres podcast Ep41 is out!
With guest Panagiotis “Panos” Antonopoulos, distinguished engineer at Microsoft, on what it’s like to work on PostgreSQL after 13 years on SQL Server
Panos is brilliant and so much fun to talk to. He loves working with databases (and the Greek islands too!)
🎧 https://talkingpostgres.com/episodes/working-on-postgres-after-13-years-on-sql-server-with-panagiotis-antonopoulos
📺 https://www.youtube.com/watch?v=5jAAPGXVfPQ&list=PLixnExCn6lRrb_wV1yV9thFI1r7DOPhER#podcast #TalkingPostgres #PostgreSQL #Postgres #databases #Azure #OpenSource #SQL
-
🎙️ New Talking Postgres podcast Ep41 is out!
With guest Panagiotis “Panos” Antonopoulos, distinguished engineer at Microsoft, on what it’s like to work on PostgreSQL after 13 years on SQL Server
Panos is brilliant and so much fun to talk to. He loves working with databases (and the Greek islands too!)
🎧 https://talkingpostgres.com/episodes/working-on-postgres-after-13-years-on-sql-server-with-panagiotis-antonopoulos
📺 https://www.youtube.com/watch?v=5jAAPGXVfPQ&list=PLixnExCn6lRrb_wV1yV9thFI1r7DOPhER#podcast #TalkingPostgres #PostgreSQL #Postgres #databases #Azure #OpenSource #SQL
-
🎙️ New Talking Postgres podcast Ep41 is out!
With guest Panagiotis “Panos” Antonopoulos, distinguished engineer at Microsoft, on what it’s like to work on PostgreSQL after 13 years on SQL Server
Panos is brilliant and so much fun to talk to. He loves working with databases (and the Greek islands too!)
🎧 https://talkingpostgres.com/episodes/working-on-postgres-after-13-years-on-sql-server-with-panagiotis-antonopoulos
📺 https://www.youtube.com/watch?v=5jAAPGXVfPQ&list=PLixnExCn6lRrb_wV1yV9thFI1r7DOPhER#podcast #TalkingPostgres #PostgreSQL #Postgres #databases #Azure #OpenSource #SQL
-
🎙️ New Talking Postgres podcast Ep41 is out!
With guest Panagiotis “Panos” Antonopoulos, distinguished engineer at Microsoft, on what it’s like to work on PostgreSQL after 13 years on SQL Server
Panos is brilliant and so much fun to talk to. He loves working with databases (and the Greek islands too!)
🎧 https://talkingpostgres.com/episodes/working-on-postgres-after-13-years-on-sql-server-with-panagiotis-antonopoulos
📺 https://www.youtube.com/watch?v=5jAAPGXVfPQ&list=PLixnExCn6lRrb_wV1yV9thFI1r7DOPhER#podcast #TalkingPostgres #PostgreSQL #Postgres #databases #Azure #OpenSource #SQL
-
🎙️ New Talking Postgres podcast Ep41 is out!
With guest Panagiotis “Panos” Antonopoulos, distinguished engineer at Microsoft, on what it’s like to work on PostgreSQL after 13 years on SQL Server
Panos is brilliant and so much fun to talk to. He loves working with databases (and the Greek islands too!)
🎧 https://talkingpostgres.com/episodes/working-on-postgres-after-13-years-on-sql-server-with-panagiotis-antonopoulos
📺 https://www.youtube.com/watch?v=5jAAPGXVfPQ&list=PLixnExCn6lRrb_wV1yV9thFI1r7DOPhER#podcast #TalkingPostgres #PostgreSQL #Postgres #databases #Azure #OpenSource #SQL
-
From the #Turso project: "We're building #Postgres in Rust. Using the #LLVM of databases"
https://turso.tech/blog/a-new-modern-version-of-postgres-in-rust
-
From the #Turso project: "We're building #Postgres in Rust. Using the #LLVM of databases"
https://turso.tech/blog/a-new-modern-version-of-postgres-in-rust
-
From the #Turso project: "We're building #Postgres in Rust. Using the #LLVM of databases"
https://turso.tech/blog/a-new-modern-version-of-postgres-in-rust
-
From the #Turso project: "We're building #Postgres in Rust. Using the #LLVM of databases"
https://turso.tech/blog/a-new-modern-version-of-postgres-in-rust
-
From the #Turso project: "We're building #Postgres in Rust. Using the #LLVM of databases"
https://turso.tech/blog/a-new-modern-version-of-postgres-in-rust
-
PostgreSQL 19 Beta 1 has been out since June 4; GA is targeted for around September/October. The window to test your workload against it is now, not in the fall.
Tooling is catching up: powa-archivist 5.2.0 (July 12) adds PG19 support. Defaults that changed: JIT is off by default, and default_toast_compression is now lz4.
https://www.postgresql.org/about/news/postgresql-19-beta-1-released-3313/
-
PostgreSQL 19 Beta 1 has been out since June 4; GA is targeted for around September/October. The window to test your workload against it is now, not in the fall.
Tooling is catching up: powa-archivist 5.2.0 (July 12) adds PG19 support. Defaults that changed: JIT is off by default, and default_toast_compression is now lz4.
https://www.postgresql.org/about/news/postgresql-19-beta-1-released-3313/
-
PostgreSQL 19 Beta 2 just dropped! 🎉 Get ready for native Graph Queries (SQL/PGQ), `REPACK CONCURRENTLY` for zero-downtime table reorganization, and loads of quality-of-life improvements. Feature freeze is ON, so now's the time to test your workloads. What feature are you most excited to try?
Read more: https://craftedsilicon.com/postgresql-19-beta-2-is-here-graph-queries-repack-and-everything-new-in-postgres-this-summer/
#PostgreSQL #Postgres #Database #DevLife #TechNews -
Looking Forward to #Postgres 19: Logically Sequenced https://www.pgedge.com/blog/looking-forward-to-postgres-19-logically-sequenced
-
Looking Forward to #Postgres 19: Logically Sequenced https://www.pgedge.com/blog/looking-forward-to-postgres-19-logically-sequenced
-
Your weekend watch is “Full Text Search in Postgres” with Philippe Noël:
-
Your weekend watch is “Full Text Search in Postgres” with Philippe Noël:
-
-
-
Как фильтр Блума ускоряет JOIN'ы в PostgreSQL
Как ускорить Hash Join в PostgreSQL, отбросив 99% строк ещё до самого соединения? Рассказываем о фильтре Блума в СУБД Tantor Postgres на живых и синтетических примерах.
https://habr.com/ru/companies/tantor/articles/1060058/
#postgresql #postgres #tantor #tantor_postgres #1c #фильтр_блума #bloom #bloom_filter
-
PG Summit US is a community conference sponsored by PgUS, providing Postgres users and developers an opportunity to sharpen their technical skills, build relationships, and connect with a community of professionals passionate about Postgres.
-
PG Summit US is a community conference sponsored by PgUS, providing Postgres users and developers an opportunity to sharpen their technical skills, build relationships, and connect with a community of professionals passionate about Postgres.
-
PostgreSQL 19 lets you turn data checksums on (and off) on a running cluster with one function call: SELECT pg_enable_data_checksums(). No offline pg_checksums pass, no multi-hour outage to get corruption detection onto an old cluster.
It isn't free: you pay in WAL and background I/O during conversion, with cost_delay and cost_limit to throttle it. That still beats a maintenance window measured in hours.
https://www.pgedge.com/blog/looking-forward-to-postgres-19-checksums-for-all
-
PostgreSQL 19 lets you turn data checksums on (and off) on a running cluster with one function call: SELECT pg_enable_data_checksums(). No offline pg_checksums pass, no multi-hour outage to get corruption detection onto an old cluster.
It isn't free: you pay in WAL and background I/O during conversion, with cost_delay and cost_limit to throttle it. That still beats a maintenance window measured in hours.
https://www.pgedge.com/blog/looking-forward-to-postgres-19-checksums-for-all
-
Have you ever wanted to converse with a book? You can't, but the next best thing is to jump on a live stream and have the author explain it to you directly. Join me tomorrow on LinkedIn Live and find out what to do when a bad database lands in your vicinity.
🗓️ Fri, Jul 17 | 10am ET/3pm BST
Grab your spot: https://hubs.la/Q04pGkS_0
-
Have you ever wanted to converse with a book? You can't, but the next best thing is to jump on a live stream and have the author explain it to you directly. Join me tomorrow on LinkedIn Live and find out what to do when a bad database lands in your vicinity.
🗓️ Fri, Jul 17 | 10am ET/3pm BST
Grab your spot: https://hubs.la/Q04pGkS_0
-
When you engage with PGX, you are engaging with the PostgreSQL Community. How do we do that? Click the link below to learn more:
-
When you engage with PGX, you are engaging with the PostgreSQL Community. How do we do that? Click the link below to learn more:
-
Our online affiliated PUGs are looking for speakers! If you aren’t local to an in-person PUG, we can put you in touch with the organizers of Postgres for All and SF PUG. Contact us today and grow your reputation as a speaker!
-
Our online affiliated PUGs are looking for speakers! If you aren’t local to an in-person PUG, we can put you in touch with the organizers of Postgres for All and SF PUG. Contact us today and grow your reputation as a speaker!
-
Сможет ли DB Client от OpenIDE заменить DataGrip?
Меня заинтересовал новый плагин DB Client , который идёт в составе OpenIDE. Давайте посмотрим, может ли он уже на текущий момент стать достойной альтернативой платному DataGrip? Я не предъявляю каких-то узкоспециальных требований к таким инструментам. В основном требуется писать и оптимизировать sql-запросы, просматривать структуру таблиц и диаграмму связей между ними, просматривать актуальный DDL, выполнять мелкие правки данных “на лету”, а также делать импорт и экспорт данных в различных форматах. Давайте по этим пунктам и пройдёмся.
-
Welcome credativ GmbH (@credativde) as a Bronze sponsor of PGConf.EU 2026 in Valencia!
-
Welcome credativ GmbH (@credativde) as a Bronze sponsor of PGConf.EU 2026 in Valencia!
-
#Postgres War Stories Part 2: multixact wraparound, TOAST corruption, and torn pages - Payal Singh https://payalsingh.me/blog/2026/06/16/postgres-war-stories-2-silent-corruption/
-
#Postgres War Stories Part 2: multixact wraparound, TOAST corruption, and torn pages - Payal Singh https://payalsingh.me/blog/2026/06/16/postgres-war-stories-2-silent-corruption/
-
New blog post: #PostgreSQL's LISTEN/NOTIFY is elegant and lightweight. It can also quietly bring a busy database to its knees. In my #POSETTE and PG DATA talk I dig into a real production incident and the fix that got us out of it.
https://vyruss.org/blog/listen-carefully-how-notify-can-trip-up-your-database.html