Mastodon

Pg Day ChicagoTake a look at the “Anatomy of Table-Level Locks in PostgreSQL” with Gülçin Yıldırım Jelínek at Pg Day Chicago 2025!<a href="https://postgresql.us/events/pgdaychicago2025/sessions/session/1903-anatomy-of-table-level-locks-in-postgresql/" rel="nofollow noopener" translate="no" target="_blank">https://postgresql.us/events/pgdaychicago2025/sessions/session/1903-anatomy-of-table-level-locks-in-postgresql/</a>@PostgreSQL <a href="https://fosstodon.org/tags/postgres" class="mention hashtag" rel="nofollow noopener" target="_blank">#postgres</a> <a href="https://fosstodon.org/tags/conference" class="mention hashtag" rel="nofollow noopener" target="_blank">#conference</a>

James GayferIs it a code smell for a table in Postgres to have mutually exclusive foreign keys?For example, table A has foreign keys to table B and C, but there's a constraint in place where only one of those foreign keys can be populated.My gut says I should be creating separate tables for these, as I'm effectively trying to tie a single table to multiple domain models (that happen to share the same fields).<a href="https://fosstodon.org/tags/postgres" class="mention hashtag" rel="nofollow noopener" target="_blank">#postgres</a> <a href="https://fosstodon.org/tags/database" class="mention hashtag" rel="nofollow noopener" target="_blank">#database</a> <a href="https://fosstodon.org/tags/databases" class="mention hashtag" rel="nofollow noopener" target="_blank">#databases</a>

Esparta :ruby:How fast can an ActiveRecord SQL query run?, by Fritz Meissner <a href="https://thoughtbot.com/blog/how-fast-can-an-activerecord-sql-query-run" rel="nofollow noopener" translate="no" target="_blank">https://thoughtbot.com/blog/how-fast-can-an-activerecord-sql-query-run</a>> Your database monitoring (perhaps Amazon RDS performance insights, Skylight, or the <a href="https://ruby.social/tags/Postgres" class="mention hashtag" rel="nofollow noopener" target="_blank">#Postgres</a> pg_stat_activity view) is telling you that one particular query in your Rails app is causing heavy load. Unfortunately, it already seems pretty fast. What are the odds that you can get it to run any faster?<a href="https://ruby.social/tags/ruby" class="mention hashtag" rel="nofollow noopener" target="_blank">#ruby</a> <a href="https://ruby.social/tags/SQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#SQL</a> <a href="https://ruby.social/tags/ActiveRecord" class="mention hashtag" rel="nofollow noopener" target="_blank">#ActiveRecord</a>

Douglas J HunleyEasy Totals and Subtotals in <a href="https://fosstodon.org/tags/Postgres" class="mention hashtag" rel="nofollow noopener" target="_blank">#Postgres</a> with Rollup and Cube | Crunchy Data Blog <a href="https://www.crunchydata.com/blog/easy-totals-and-subtotals-in-postgres-with-rollup-and-cube" rel="nofollow noopener" translate="no" target="_blank">https://www.crunchydata.com/blog/easy-totals-and-subtotals-in-postgres-with-rollup-and-cube</a>

Pg Day ChicagoApril in Chicago? What could be better? How about learning new things about PostgreSQL and networking with like minded professionals! Tickets are available now for Pg Day Chicago 2025!<a href="https://2025.pgdaychicago.org/tickets/" rel="nofollow noopener" translate="no" target="_blank">https://2025.pgdaychicago.org/tickets/</a>@PostgreSQL <a href="https://fosstodon.org/tags/postgres" class="mention hashtag" rel="nofollow noopener" target="_blank">#postgres</a> <a href="https://fosstodon.org/tags/conference" class="mention hashtag" rel="nofollow noopener" target="_blank">#conference</a>

PgUSWould you like to see a more inclusive and diverse PostgreSQL community? We would too! Consider joining the PgUS Diversity Committee to help make that a reality!<a href="https://postgresql.us/diversity/" rel="nofollow noopener" translate="no" target="_blank">https://postgresql.us/diversity/</a><a href="https://fosstodon.org/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#PostgreSQL</a> <a href="https://fosstodon.org/tags/postgres" class="mention hashtag" rel="nofollow noopener" target="_blank">#postgres</a> <a href="https://fosstodon.org/tags/diversity" class="mention hashtag" rel="nofollow noopener" target="_blank">#diversity</a> <a href="https://fosstodon.org/tags/inclusion" class="mention hashtag" rel="nofollow noopener" target="_blank">#inclusion</a>

Douglas J Hunley<a href="https://fosstodon.org/tags/Postgres" class="mention hashtag" rel="nofollow noopener" target="_blank">#Postgres</a> Language Server: Initial Release | Hacker News <a href="https://news.ycombinator.com/item?id=43513996" rel="nofollow noopener" translate="no" target="_blank">https://news.ycombinator.com/item?id=43513996</a>

HabrSandbox DB: универсальная песочница для погружения в Big Data, аналитику и визуализациюЗапускайте PostgreSQL, ClickHouse, Airflow, Superset и другие инструменты одним кликом: учите, экспериментируйте, осваивайте новое!<a href="https://habr.com/ru/articles/896054/" rel="nofollow noopener" translate="no" target="_blank">https://habr.com/ru/articles/896054/</a><a href="https://zhub.link/tags/%D0%B0%D0%BD%D0%B0%D0%BB%D0%B8%D0%B7_%D0%B4%D0%B0%D0%BD%D0%BD%D1%8B%D1%85" class="mention hashtag" rel="nofollow noopener" target="_blank">#анализ_данных</a> <a href="https://zhub.link/tags/%D0%B1%D0%B0%D0%B7%D1%8B_%D0%B4%D0%B0%D0%BD%D0%BD%D1%8B%D1%85" class="mention hashtag" rel="nofollow noopener" target="_blank">#базы_данных</a> <a href="https://zhub.link/tags/python" class="mention hashtag" rel="nofollow noopener" target="_blank">#python</a> <a href="https://zhub.link/tags/spark" class="mention hashtag" rel="nofollow noopener" target="_blank">#spark</a> <a href="https://zhub.link/tags/clickhouse" class="mention hashtag" rel="nofollow noopener" target="_blank">#clickhouse</a> <a href="https://zhub.link/tags/postgres" class="mention hashtag" rel="nofollow noopener" target="_blank">#postgres</a> <a href="https://zhub.link/tags/superset" class="mention hashtag" rel="nofollow noopener" target="_blank">#superset</a>

PGDay UKWelcome CYBERTEC as a Benefactor sponsor of PGDay UK 2024 in London! <a href="https://2024.pgday.uk/sponsors/" rel="nofollow noopener" translate="no" target="_blank">https://2024.pgday.uk/sponsors/</a> <a href="https://fosstodon.org/tags/postgres" class="mention hashtag" rel="nofollow noopener" target="_blank">#postgres</a> <a href="https://fosstodon.org/tags/pgdayuk" class="mention hashtag" rel="nofollow noopener" target="_blank">#pgdayuk</a> <a href="https://fosstodon.org/tags/london" class="mention hashtag" rel="nofollow noopener" target="_blank">#london</a> <a href="https://fosstodon.org/tags/opensource" class="mention hashtag" rel="nofollow noopener" target="_blank">#opensource</a> <a href="https://fosstodon.org/tags/database" class="mention hashtag" rel="nofollow noopener" target="_blank">#database</a>

Pg Day ChicagoPg Day Chicago 2025 is shaping up to be a great conference. But who are we? What are we all about? Click the link below to find out!<a href="https://2025.pgdaychicago.org/about/" rel="nofollow noopener" translate="no" target="_blank">https://2025.pgdaychicago.org/about/</a>@PostgreSQL <a href="https://fosstodon.org/tags/postgres" class="mention hashtag" rel="nofollow noopener" target="_blank">#postgres</a> <a href="https://fosstodon.org/tags/conference" class="mention hashtag" rel="nofollow noopener" target="_blank">#conference</a>

Pg Day ChicagoHelp us help the community by sponsoring Pg Day Chicago 2025! Talk to us about sponsorship opportunities today!<a href="https://2025.pgdaychicago.org/sponsors/" rel="nofollow noopener" translate="no" target="_blank">https://2025.pgdaychicago.org/sponsors/</a>@PostgreSQL <a href="https://fosstodon.org/tags/postgres" class="mention hashtag" rel="nofollow noopener" target="_blank">#postgres</a> <a href="https://fosstodon.org/tags/conference" class="mention hashtag" rel="nofollow noopener" target="_blank">#conference</a>

Braden DouglassI constantly see folks select ActiveRecord when going the <a href="https://ruby.social/tags/notRails" class="mention hashtag" rel="nofollow noopener" target="_blank">#notRails</a> route. I just don’t understand it when there are benchmarks like the following: <a href="https://ideia.me/benchmarking-ruby-orms" rel="nofollow noopener" translate="no" target="_blank">https://ideia.me/benchmarking-ruby-orms</a><a href="https://ruby.social/tags/postgres" class="mention hashtag" rel="nofollow noopener" target="_blank">#postgres</a> <a href="https://ruby.social/tags/performance" class="mention hashtag" rel="nofollow noopener" target="_blank">#performance</a> <a href="https://ruby.social/tags/orms" class="mention hashtag" rel="nofollow noopener" target="_blank">#orms</a>

POSETTE: An Event for Postgres🥅 "Exploring .NET and <a href="https://mastodon.social/tags/PostgreSQL" class="mention hashtag" rel="tag">#PostgreSQL</a> on Linux as your OSS app dev stack" will be presented by Silvano Coriani from Microsoft at <a href="https://mastodon.social/tags/PosetteConf" class="mention hashtag" rel="tag">#PosetteConf</a> 2025 (Livestream 2 on Wed Jun 11th @ 12:30pm CEST (UTC+2)) 🐘 Learn more: <a href="https://posetteconf.com/speakers/silvano-coriani/" target="_blank" rel="nofollow noopener" translate="no">https://posetteconf.com/speakers/silvano-coriani/</a> <a href="https://mastodon.social/tags/postgres" class="mention hashtag" rel="tag">#postgres</a> <a href="https://mastodon.social/tags/databases" class="mention hashtag" rel="tag">#databases</a>

HabrПорядок следования столбцов в таблицах PostgreSQLПорядок столбцов в таблицах влияет на компактность и производительность. При небольшом числе строк на это не обращают внимание. Если в таблицах хранится много строк, то даже небольшое уменьшение объема хранения может быть полезно. У столбцов есть оптимальный порядок и менее оптимальные, которые отличаются размером, который используют строки при физическом хранении. Причина того, что переставив столбцы строки в таблице с теми же самыми данными, меняют размер в выравнивании (aligning) и заполнении нулями (padding). В блоке данных выравниваются все структуры: заголовки, поля строк и целиком сами строки. На 64-разраядных операционных системах, длина любой строки и заголовка строки выравниваются по 8 байт. То есть если строка занимает 28 байт, то физически она займёт 32 байта. В конец строки будут добавлены пустые байты. Поля выравниваются сложнее - по 4,8, 16 байт. В статье рассматривается перестановка столбцов на примере демонстрационной базы.<a href="https://habr.com/ru/articles/895638/" rel="nofollow noopener" translate="no" target="_blank">https://habr.com/ru/articles/895638/</a><a href="https://zhub.link/tags/postgresql" class="mention hashtag" rel="nofollow noopener" target="_blank">#postgresql</a> <a href="https://zhub.link/tags/postgres" class="mention hashtag" rel="nofollow noopener" target="_blank">#postgres</a> <a href="https://zhub.link/tags/%D0%BF%D0%BE%D1%81%D1%82%D0%B3%D1%80%D0%B5%D1%81" class="mention hashtag" rel="nofollow noopener" target="_blank">#постгрес</a> <a href="https://zhub.link/tags/%D0%B2%D1%8B%D1%80%D0%B0%D0%B2%D0%BD%D0%B8%D0%B2%D0%B0%D0%BD%D0%B8%D0%B5_%D0%B4%D0%B0%D0%BD%D0%BD%D1%8B%D1%85" class="mention hashtag" rel="nofollow noopener" target="_blank">#выравнивание_данных</a>

Hacker News 50Show HN: Cloud-Ready Postgres MCP ServerLink: <a href="https://github.com/stuzero/pg-mcp" rel="nofollow noopener" translate="no" target="_blank">https://github.com/stuzero/pg-mcp</a> Discussion: <a href="https://news.ycombinator.com/item?id=43520953" rel="nofollow noopener" translate="no" target="_blank">https://news.ycombinator.com/item?id=43520953</a><a href="https://social.lansky.name/tags/postgres" class="mention hashtag" rel="nofollow noopener" target="_blank">#postgres</a>

N-gated Hacker News🚀🎩 Wow, another revolutionary server product that promises to make <a href="https://mastodon.social/tags/Postgres" class="mention hashtag" rel="tag">#Postgres</a> "cloud-ready" by magically doing... what exactly? 🌥️🧐 Apparently, it involves a cryptic mix of AI, automation, and buzzwords, with a side of GitHub jargon that only the truly enlightened could ever comprehend. But hey, at least you can "collaborate outside of code"—whatever that means! 😅👾 <a href="https://github.com/stuzero/pg-mcp" target="_blank" rel="nofollow noopener" translate="no">https://github.com/stuzero/pg-mcp</a> <a href="https://mastodon.social/tags/cloudready" class="mention hashtag" rel="tag">#cloudready</a> <a href="https://mastodon.social/tags/AIautomation" class="mention hashtag" rel="tag">#AIautomation</a> <a href="https://mastodon.social/tags/techbuzzwords" class="mention hashtag" rel="tag">#techbuzzwords</a> <a href="https://mastodon.social/tags/GitHubjargon" class="mention hashtag" rel="tag">#GitHubjargon</a> <a href="https://mastodon.social/tags/HackerNews" class="mention hashtag" rel="tag">#HackerNews</a> <a href="https://mastodon.social/tags/ngated" class="mention hashtag" rel="tag">#ngated</a>

Hacker NewsCloud-Ready Postgres MCP Server<a href="https://github.com/stuzero/pg-mcp" target="_blank" rel="nofollow noopener" translate="no">https://github.com/stuzero/pg-mcp</a><a href="https://mastodon.social/tags/HackerNews" class="mention hashtag" rel="tag">#HackerNews</a> <a href="https://mastodon.social/tags/CloudReady" class="mention hashtag" rel="tag">#CloudReady</a> <a href="https://mastodon.social/tags/Postgres" class="mention hashtag" rel="tag">#Postgres</a> <a href="https://mastodon.social/tags/MCP" class="mention hashtag" rel="tag">#MCP</a> <a href="https://mastodon.social/tags/Server" class="mention hashtag" rel="tag">#Server</a> <a href="https://mastodon.social/tags/Postgres" class="mention hashtag" rel="tag">#Postgres</a> <a href="https://mastodon.social/tags/MCP" class="mention hashtag" rel="tag">#MCP</a> <a href="https://mastodon.social/tags/Server" class="mention hashtag" rel="tag">#Server</a> <a href="https://mastodon.social/tags/GitHub" class="mention hashtag" rel="tag">#GitHub</a> <a href="https://mastodon.social/tags/CloudComputing" class="mention hashtag" rel="tag">#CloudComputing</a> <a href="https://mastodon.social/tags/Database" class="mention hashtag" rel="tag">#Database</a>

Paul Houle💽 Hans-Juergen Schoenig: PostgreSQL: 1 trillion rows in Citus<a href="https://postgr.es/p/73O" target="_blank" rel="nofollow noopener" translate="no">https://postgr.es/p/73O</a><a href="https://mastodon.social/tags/postgres" class="mention hashtag" rel="tag">#postgres</a> <a href="https://mastodon.social/tags/database" class="mention hashtag" rel="tag">#database</a> <a href="https://mastodon.social/tags/computing" class="mention hashtag" rel="tag">#computing</a> <a href="https://mastodon.social/tags/performance" class="mention hashtag" rel="tag">#performance</a> <a href="https://mastodon.social/tags/software" class="mention hashtag" rel="tag">#software</a>

Pg Day ChicagoPg Day Chicago delivers one day packed with presentations about PostgreSQL and related technologies and the usual hallway and social track. Book your ticket today!<a href="https://2025.pgdaychicago.org/tickets/" rel="nofollow noopener" translate="no" target="_blank">https://2025.pgdaychicago.org/tickets/</a>@PostgreSQL <a href="https://fosstodon.org/tags/postgres" class="mention hashtag" rel="nofollow noopener" target="_blank">#postgres</a> <a href="https://fosstodon.org/tags/conference" class="mention hashtag" rel="nofollow noopener" target="_blank">#conference</a>

Yozen Hernandez"For our fifth meetup of 2025, we're extremely excited to have Philippe Noël talking about Building a full-text search Postgres extension in Rust! Learn about how ParadeDB brings Elasticsearch-quality text search to Postgres and the kinds of challenges they've solved along the way."<a href="https://www.meetup.com/rust-nyc/events/306983122/" rel="nofollow noopener" translate="no" target="_blank">https://www.meetup.com/rust-nyc/events/306983122/</a><a href="https://fosstodon.org/tags/rustlang" class="mention hashtag" rel="nofollow noopener" target="_blank">#rustlang</a> <a href="https://fosstodon.org/tags/nyc" class="mention hashtag" rel="nofollow noopener" target="_blank">#nyc</a> <a href="https://fosstodon.org/tags/MeetUp" class="mention hashtag" rel="nofollow noopener" target="_blank">#MeetUp</a> <a href="https://fosstodon.org/tags/Postgres" class="mention hashtag" rel="nofollow noopener" target="_blank">#Postgres</a> <a href="https://fosstodon.org/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#PostgreSQL</a> <a href="https://fosstodon.org/tags/ParadeDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#ParadeDB</a>

Recent searches

Search options

Administered by:

Server stats:

#postgres