Mastodawn

#Postgres vs. #SQL Server: B-Tree Index Differences & the Benefit of Deduplication https://pganalyze.com/blog/postgresql-vs-sql-server-btree-index-deduplication

Postgres vs. SQL Server: B-Tree Index Differences & the Benefit of Deduplication

Discover how PostgreSQL and SQL Server—including Azure SQL—differ in their B-Tree index implementations, storage behavior, and performance impact. Includes benchmarks, deduplication analysis, and a side-by-side index comparison guide for engineers optimizing or migrating databases.

pganalyze

PgUS 1h ago

Our affiliated PUGs are looking for speakers! If you're local to one of the PUGs listed here: https://www.meetup.com/pro/postgresql/ and would like to present, contact us and we can put you in touch with the organizers!

https://buff.ly/4gfy2M3

#PostgreSQL #postgres

pgconfnyc 2h ago

We have a new larger venue for PGConf NYC 2025! We will be at Convene 117 West 46th Street! Check it out:

https://2025.pgconf.nyc/venue/

@PostgreSQL #postgres #conference

Code of Amor 💘4h ago

Perhaps next I could give a statistical analysis based on usage per toot?
#swearing
#fbombs
#sql
#postgres
#mastodon
#starwars

HackerNews VN bot 9h ago

Ứng dụng Clipzy cho phép tìm kiếm đoạn hội thoại trong phim và chương trình TV theo thời gian thực! Dữ liệu được xử lý từ OpenSubtitles.org, sử dụng PostgreSQL và flexsearch. Tác giả có kế hoạch thêm tìm kiếm vector phía server và cải thiện dữ liệu.

#clipzy #opensubtitles #postgres #flexsearch #ứngdụng #phim #tv #timkiem

https://clipzy.app/

pgconfnyc 18h ago

Has your company sponsored PostgreSQL events in the past? Well let them know that PGConf NYC 2025 has sponsorship opportunities available!

https://2025.pgconf.nyc/sponsors/

@PostgreSQL #postgres #conference

pgconfnyc 21h ago

Join us for “Mastering Time-Series Data in PostgreSQL: Advanced Partitioning Strategies and BRIN Indexes (Block Range INdexes) to Speed up the Ingestion” with Domenico di Salvia at PGConf NYC 2025!

https://postgresql.us/events/pgconfus2025/sessions/session/1970-mastering-time-series-data-in-postgresql-advanced-partitioning-strategies-and-brin-indexes-block-range-indexes-to-speed-up-the-ingestion/

@PostgreSQL #postgres #conference

Douglas J Hunley 22h ago

#Postgres backend statistics (Part 2): WAL statistics https://bdrouvot.github.io/2025/04/02/postgres-backend-statistics-part-2/

Postgres backend statistics (Part 2): WAL statistics

Introduction PostgreSQL 18 will normally (as there is always a risk of seeing something reverted until its GA release) include those commits: Add data for WAL in pg_stat_io and backend statistics: commit a051e71e28a12342a4fb39a3c149a197159f9c46 Author: Michael Paquier <michael@paquier.xyz> Date: Tue Feb 4 16:50:00 2025 +0900 Add data for WAL in pg_stat_io...

BayAreaPostgres 1d ago

Join us on Tuesday, August 12th at Noon PDT for "Gathering of the Herd - SF PUG Celebrates World Elephant Day!” with Federico Campoli and Stacey Haysler!

https://www.meetup.com/postgresql-1/events/309042260/?eventOrigin=group_events_list

@PostgreSQL #PostgreSQL #postgres #meetup

PgUS 1d ago

Collaboration is key when it comes to creating a diverse and inclusive community. The members of our Diversity Committee are constantly working towards the goal of a vibrant and collaborative community.

https://postgresql.us/diversity/

#PostgreSQL #postgres #diversity #inclusion