Create accountLogin

Recent searches

No recent searches

Search options

Only available when logged in.
digitalcourage.social is one of the many independent Mastodon servers you can use to participate in the fediverse.
Diese Instanz wird betrieben von Digitalcourage e.V. für die Allgemeinheit. Damit wir das nachhaltig tun können, erheben wir einen jährlichen Vorausbeitrag von 1€/Monat per SEPA-Lastschrifteinzug.

Administered by:

Server stats:

812
active users

digitalcourage.social: AboutStatusProfiles directoryPrivacy policy

Mastodon: AboutGet the appKeyboard shortcutsView source codev4.3.8

#postgres

47 posts31 participants10 posts today
Douglas J Hunley<p><a href="https://fosstodon.org/tags/Postgres" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Postgres</span></a> Extension Tutorial <a href="https://github.com/IshaanAdarsh/Postgres-extension-tutorial/blob/main/SGML/intro_and_toc.md" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">github.com/IshaanAdarsh/Postgr</span><span class="invisible">es-extension-tutorial/blob/main/SGML/intro_and_toc.md</span></a></p>
pgconfnyc<p>Join us for “Improved Freezing in Postgres Vacuum: From Idea to Commit” with Melanie Plageman at PGConf NYC 2025!</p><p><a href="https://postgresql.us/events/pgconfus2025/sessions/session/2080-improved-freezing-in-postgres-vacuum-from-idea-to-commit/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">postgresql.us/events/pgconfus2</span><span class="invisible">025/sessions/session/2080-improved-freezing-in-postgres-vacuum-from-idea-to-commit/</span></a></p><p>@PostgreSQL <a href="https://fosstodon.org/tags/postgres" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>postgres</span></a> <a href="https://fosstodon.org/tags/conference" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>conference</span></a></p>
Hacker News 50<p>We made Postgres writes faster, but it broke replication</p><p>Link: <a href="https://www.paradedb.com/blog/lsm_trees_in_postgres" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://www.</span><span class="ellipsis">paradedb.com/blog/lsm_trees_in</span><span class="invisible">_postgres</span></a><br>Discussion: <a href="https://news.ycombinator.com/item?id=44633933" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">news.ycombinator.com/item?id=4</span><span class="invisible">4633933</span></a></p><p><a href="https://social.lansky.name/tags/postgres" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>postgres</span></a></p>
:rss: Hacker News<p>We made Postgres writes faster, but it broke replication<br><a href="https://www.paradedb.com/blog/lsm_trees_in_postgres" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://www.</span><span class="ellipsis">paradedb.com/blog/lsm_trees_in</span><span class="invisible">_postgres</span></a><br><a href="https://rss-mstdn.studiofreesia.com/tags/ycombinator" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>ycombinator</span></a> <a href="https://rss-mstdn.studiofreesia.com/tags/Postgres" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Postgres</span></a> <a href="https://rss-mstdn.studiofreesia.com/tags/search" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>search</span></a> <a href="https://rss-mstdn.studiofreesia.com/tags/analytics" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>analytics</span></a> <a href="https://rss-mstdn.studiofreesia.com/tags/ETL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>ETL</span></a> <a href="https://rss-mstdn.studiofreesia.com/tags/Elasticsearch" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Elasticsearch</span></a> <a href="https://rss-mstdn.studiofreesia.com/tags/OLAP" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>OLAP</span></a></p>
BayAreaPostgres<p>We're always looking for speakers for our virtual Meetups! Got something to share? We'd love to hear from you! Drop us a DM on Meetup and you could be our next speaker! </p><p><a href="https://www.meetup.com/postgresql-1/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://www.</span><span class="">meetup.com/postgresql-1/</span><span class="invisible"></span></a></p><p><a href="https://fosstodon.org/tags/speaker" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>speaker</span></a> <a href="https://fosstodon.org/tags/postgres" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>postgres</span></a> <a href="https://fosstodon.org/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PostgreSQL</span></a> <a href="https://fosstodon.org/tags/bayareapostgres" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>bayareapostgres</span></a></p>
Douglas J Hunley<p><a href="https://fosstodon.org/tags/Postgres" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Postgres</span></a> FM | PgDog <a href="https://fosstodon.org/tags/podcast" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>podcast</span></a> <a href="https://share.transistor.fm/s/401bfa5b" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">share.transistor.fm/s/401bfa5b</span><span class="invisible"></span></a></p>
PgUS<p>We want you, yes you, to join PgUS! Why? To help bring more resources and education to the PostgreSQL community! Join today!</p><p><a href="https://postgresql.us/becomeamember/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">postgresql.us/becomeamember/</span><span class="invisible"></span></a></p><p><a href="https://fosstodon.org/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PostgreSQL</span></a> <a href="https://fosstodon.org/tags/postgres" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>postgres</span></a></p>
EDB<p>Are we overcomplicating how our applications talk to <a href="https://mastodon.social/tags/Postgres" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Postgres</span></a>?</p><p>In this new technical blog, EDB’s Manni Wood makes the case for a more streamlined approach—one that skips heavy ORMs and goes straight from SQL to clean, native data structures.</p><p>🔹 No query builder<br>🔹 No manual deserialization<br>🔹 Just tested SQL + pgx v5 in Go (or your language of choice)</p><p>It’s a helpful read for developers building APIs, microservices, or anything that passes Postgres data forward ▶️ <a href="https://www.enterprisedb.com/blog/streamline-how-your-code-interacts-postgres" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://www.</span><span class="ellipsis">enterprisedb.com/blog/streamli</span><span class="invisible">ne-how-your-code-interacts-postgres</span></a></p>
pgconfnyc<p>PGConf NYC delivers three days packed with presentations about PostgreSQL and related technologies and the usual hallway and social track. Book your ticket today!</p><p><a href="https://2025.pgconf.nyc/tickets/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">2025.pgconf.nyc/tickets/</span><span class="invisible"></span></a></p><p>@PostgreSQL <a href="https://fosstodon.org/tags/postgres" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>postgres</span></a> <a href="https://fosstodon.org/tags/conference" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>conference</span></a></p>
Jan<p>If you ever change the database in your Phoenix project from <a href="https://x0r.be/tags/postgresql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>postgresql</span></a> to <a href="https://x0r.be/tags/sqlite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sqlite</span></a> remember to remover the `async: true` parts from the use `Project.ConnCase` in your tests.</p><p>Otherwise a lot of `(Exqlite.Error) Database busy` will show up in your tests.</p><p>Another way to "fix" this is to set the `pool_size` to 1 in your tests.exs. But in reality that's just a workaround.</p><p><a href="https://x0r.be/tags/elixir" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>elixir</span></a> <a href="https://x0r.be/tags/erlang" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>erlang</span></a> <a href="https://x0r.be/tags/postgres" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>postgres</span></a> <a href="https://x0r.be/tags/postgresql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>postgresql</span></a> <a href="https://x0r.be/tags/sqlite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sqlite</span></a></p>
pgconfnyc<p>Want to attend PGConf NYC 2025 but not sure how to fund it? As a community event PGConf NYC is covered by the PgUS Diversity Scholarship to support underrepresented Postgres users. </p><p><a href="https://docs.google.com/forms/d/1dgFUVXHgJ0sLAETJaAciLFetvFq5_S0-juZ3g8QyeVc/edit?ts=58f14198" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">docs.google.com/forms/d/1dgFUV</span><span class="invisible">XHgJ0sLAETJaAciLFetvFq5_S0-juZ3g8QyeVc/edit?ts=58f14198</span></a></p><p>@PostgreSQL <a href="https://fosstodon.org/tags/postgres" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>postgres</span></a> <a href="https://fosstodon.org/tags/conference" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>conference</span></a> <a href="https://fosstodon.org/tags/diversity" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>diversity</span></a></p>
BayAreaPostgres<p>We hope you’ll be joining 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!</p><p><a href="https://www.meetup.com/postgresql-1/events/309042260/?eventOrigin=group_events_list" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://www.</span><span class="ellipsis">meetup.com/postgresql-1/events</span><span class="invisible">/309042260/?eventOrigin=group_events_list</span></a></p><p>@PostgreSQL <a href="https://fosstodon.org/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PostgreSQL</span></a> <a href="https://fosstodon.org/tags/postgres" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>postgres</span></a> <a href="https://fosstodon.org/tags/meetup" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>meetup</span></a></p>
Ulf Rompe<p>Hm. I normally use <a href="https://github.com/pgautoupgrade/docker-pgautoupgrade" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">github.com/pgautoupgrade/docke</span><span class="invisible">r-pgautoupgrade</span></a> whenever I need to deploy a <a href="https://mastodon.social/tags/postgres" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>postgres</span></a> container because I can just increase the version in my <a href="https://mastodon.social/tags/Ansible" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Ansible</span></a> playbooks to perform an upgrade.</p><p>Now I need <a href="https://mastodon.social/tags/postgis" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>postgis</span></a> for <a href="https://mastodon.social/tags/dawarich" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>dawarich</span></a> and there doesn't seem to be such a convenient fork to ease future upgrades. </p><p>Am I missing something? Do I really want to bother future-me with manual upgrades that may include dumping, updating and restoring? Or would I just add these steps to my playbook?</p>
Herbert Hertramph<p>Paperless-ngx:</p><p>Inzwischen wird ja die Postgres-Version 17 verwendet.</p><p>Falls jemand schon länger kein Update gemacht hat: Noch mal ein (1-Klick)-Backup vor dem Update durchführen.</p><p>Ansonsten: Wenn man Paperless-ngx so installiert hat, wie ich es vorgeschlagen habe, kann man sich bequem zurücklehnen und das Update auf Version 2.17.1 wie gewohnt durchführen. Neue Datenbankversion usw. passiert alles automatisch.</p><p><a href="https://bildung.social/tags/paperless" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>paperless</span></a> <a href="https://bildung.social/tags/paperlessngx" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>paperlessngx</span></a> <a href="https://bildung.social/tags/postgres" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>postgres</span></a></p>
pgconfnyc<p>Learn all about “Hybrid Search on Postgres at Scale” with Ankit Mittal at PGConf NYC 2025!</p><p><a href="https://postgresql.us/events/pgconfus2025/sessions/session/2100-hybrid-search-on-postgres-at-scale/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">postgresql.us/events/pgconfus2</span><span class="invisible">025/sessions/session/2100-hybrid-search-on-postgres-at-scale/</span></a></p><p>@PostgreSQL <a href="https://fosstodon.org/tags/postgres" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>postgres</span></a> <a href="https://fosstodon.org/tags/conference" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>conference</span></a></p>
pgconfnyc<p>We have a new larger venue for PGConf NYC 2025! We will be at Convene 117 West 46th Street! Check it out: </p><p><a href="https://2025.pgconf.nyc/venue/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">2025.pgconf.nyc/venue/</span><span class="invisible"></span></a></p><p>@PostgreSQL <a href="https://fosstodon.org/tags/postgres" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>postgres</span></a> <a href="https://fosstodon.org/tags/conference" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>conference</span></a></p>
pgconfnyc<p>By sponsoring PGConf NYC 2025, your company can be a part of building the local PostgreSQL community! Check out our sponsorship opportunities today!</p><p><a href="https://2025.pgconf.nyc/sponsors/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">2025.pgconf.nyc/sponsors/</span><span class="invisible"></span></a></p><p>@PostgreSQL <a href="https://fosstodon.org/tags/postgres" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>postgres</span></a> <a href="https://fosstodon.org/tags/conference" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>conference</span></a></p>
Douglas J Hunley<p>Converting <a href="https://fosstodon.org/tags/JSON" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>JSON</span></a> documents to relational tables - <a href="https://fosstodon.org/tags/Postgres" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Postgres</span></a> OnLine Journal <a href="https://www.postgresonline.com/journal/index.php?/archives/420-Converting-JSON-documents-to-relational-tables.html" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://www.</span><span class="ellipsis">postgresonline.com/journal/ind</span><span class="invisible">ex.php?/archives/420-Converting-JSON-documents-to-relational-tables.html</span></a></p>
Douglas J Hunley<p>A Practical Guide to <a href="https://fosstodon.org/tags/Postgres" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Postgres</span></a> Isolation Anomalies and How To Tame Them <a href="https://dansvetlov.me/postgres-anomalies/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">dansvetlov.me/postgres-anomali</span><span class="invisible">es/</span></a></p>
PgUS<p>We want everyone’s voice to be heard in the herd and our Diversity Committee works hard to make sure that’s a reality! Take a look:</p><p><a href="https://postgresql.us/diversity/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">postgresql.us/diversity/</span><span class="invisible"></span></a></p><p><a href="https://fosstodon.org/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PostgreSQL</span></a> <a href="https://fosstodon.org/tags/postgres" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>postgres</span></a> <a href="https://fosstodon.org/tags/diversity" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>diversity</span></a> <a href="https://fosstodon.org/tags/inclusion" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>inclusion</span></a></p>
ExploreLive feeds
About