Recent searches
Search options
#postgresql
Come see Bilge Ince and Boriss Mejias (@tchorix) talk about "From Distance to Intelligence: Evolving Your Vector Search"!
Postgres is actually all you need. No need to build a complex setup of different databases.
I use postgres for all data storage requirements. I've been using it as a vector store too. It's been holding up very nicely.
Developers attending #PgDayChicago, do you have any students or know any who would like to learn about #PostgreSQL?
Bring them to Student PG Data Day the day before (April 24) in the same location, a FREE event with Laetitia Avrot and Shaun Thomas presenting on "DBA in a Box" and "Introduction to Database Design & Optimization".
Learn more at https://prairiepostgres.org 
I’ve never had this happen before! A Postgres index got corrupted in dev.
I’m not sure when it broke, it may have been an OS update or a Postgres update, but logins to this app stopped working which uses a lower(email) index.
I had to run a `REINDEX TABLE CONCURRENTLY users` command to fix it
That was a fun one to debug 
Why #PostgreSQL major version upgrades are hard https://peter.eisentraut.org/blog/2024/11/26/why-postgresql-major-version-upgrades-are-hard
New entry in #PostgreSQL Event Calendar:
CfP FOSSY 2025
Date: 2025-04-28
Location: Portland, Oregon, United States
ICS file: https://ics.postgresql.life/6srj8o9l60smcb9h6kqj4b9kccqjebb16kqj6bb5c4ojid1j6opj0pb264.ics
Implementing SQL JOIN Support in ChronDB via PostgreSQL Protocol
The game of creating databases using #git internals continues
this week was the time to implement inner/left/right join in the #postgresql protocol
I tried to explain a little about the architecture implemented to perform joins
https://www.moclojer.com/blog/implementing-sql-join-support-in-chrondb-via-postgresql-protocol/
New entry in #PostgreSQL Event Calendar:
Armenia PostgreSQL User Group
Date: 2025-04-26T14:30:00Z - 2025-04-26T18:00:00Z
Location: 3 Hakob Hakobyan, Yerevan, am
ICS file: https://ics.postgresql.life/6a1tif5s313k20o7hl3epmkedl.ics
#PostgreSQL Event Calendar, Reminder:
Boston Meetup: Kubernetes operators for Postgres
Date: 2025-04-17T22:30:00Z - 2025-04-18T00:30:00Z
Location: Filippo's Restaurant 283 Causeway St · Boston, MA
ICS file: https://ics.postgresql.life/7kfoa5lv6j0hdcpesv9agk64uf.ics
There is plenty going on around the #PGConfDev conference in #Montreal. Did you know there is also a #PostgreSQL Extension Ecosystem Summit? If not, now is a good time to get a ticket!
If you are coming to #PGConfDE to #Berlin and stay a day longer, you can go to a #Spreewald trip, organized by @sjstoelting
Visiting Spreewald is always worth it. You can go by train from Berlin. Hiking, barge, kayak or canoe tours are available.
More information and signup here:
Today I discovered "lnav"or the Log Navigator cli utility. It is a truly awesome log follower and navigator for the terminal which works beautifully with PostgreSQL log files.
#postgres #postgresql #debugging #sql #plpgsql #lnav #logs #logging #rdbms #system #administration
I started my own pastebin solution a few years ago to share snippets with my colleagues. I ordered a VPS, deployed Sticky Notes and PostgreSQL. I wrote a client in Perl (for learning purpose) and my manager wrote the client in Go. It's easy to use and it was fun. We started to share snippets then more and more people did the same.
https://github.com/sayakb/sticky-notes
From day 1, the service was a side project without any guarantee of availability and security, even if I'm not crazy, it's not open on the internet and it runs on our own infrastructure.
I put a joke on the front page. But who cares? We use a CLI tool anyway. We almost never reach the front page. It's funny to see newcomers wondering what is the meaning of the mysterious phrase on this awesome service. They don't even know that I'm the one "managing" the service (it runs by itself in reality).
But today, the unprofessional joke is gone. The service will soon be handed over another team because it's their job. RIP my little successful pastebin 
Guillaume continue de partager les nouveautés de la version 18 de #PostgreSQL, qui sortira en septembre prochain selon la feuille de route communautaire.
Ce mois-ci, il vous parle de la nouvelle option pour la commande EXPLAIN, proposée par @robertmhaas =>
https://dali.bo/202504_pg18
New entry in #PostgreSQL Event Calendar:
PostgresMeetup for All: Troubleshoot Slow Queries Using Postgres EXPLAIN Visualizations
Date: 2025-05-14T16:00:00Z - 2025-05-14T17:00:00Z
ICS file: https://ics.postgresql.life/6v8fjgeb8fj2tieu74i2fr04fl.ics
Play Wordle in Your PostgreSQL Database: A SQL Implementation
Imagine playing the popular Wordle game directly from your PostgreSQL database! This innovative implementation not only showcases SQL's capabilities but also offers a fun way to engage with database q...
https://news.lavx.hu/article/play-wordle-in-your-postgresql-database-a-sql-implementation
We're happy to see our own Frédéric has been interviewed as a #PostgresFriend! See his interview with @ascherbaum on #PostgreSQLLife:
Save the Date! PostgreSQL - Open Day 2025 is coming to Bolzano, Italy! 
April 11, 2025
NOI Techpark
Explore cutting-edge research & innovation:
Connect with experts. Learn about groundbreaking projects in PostgreSQL. Participate in hands-on workshops and activities.
Full podcast 
: https://link.illustris.org/openday2025
Join us for a day of discovery in beautiful Bolzano. Let's shape the future together! 
