Chris Ellis @intrbiz@bergamot.social

Vector search is actually terrible at keywords.

Try searching for a specific SKU using only embeddings. Good luck.

Everyone is obsessed with semantic search, but sometimes you need exact matches. This is where Postgres dominates specialized vector stores.

Strategy: Hybrid Search (Keyword + Semantic).
Tool: Postgres tsvector (Full Text Search) + pgvector
Result: RAG accuracy improves by ~40% when you combine methods.

#vector #pgvector #postgres #postgresql #dougortiz #rag

If you have any Postgres performance issues, I'd love to hear about them and try to help: https://pgmustard.com/office-hours

Many happy returns to everyone who has, for security purposes, given 1st January as their birthday when registering for online services.

#AI didn't make us smarter. It just gave idiots a superpower.
Hoping for a less triggering 2026

Project manager: "What's technical debt? Explain it to me like I'm 6 years old"

Devs:

(source: "Richard Scarry's Storybook Dictionary" : https://archive.org/details/1scarryRichardStorybookDictionary/page/n56/mode/1up )

People from Fujitsu and the Post Office need to be in prison.

#PostOfficeScandal

https://www.bbc.co.uk/news/articles/cqlkx6n15ero

The first #PostgreSQL #Edinburgh meetup was a success! Did you miss @vyruss delivering RAGTime with Postgres?

His comprehensive slides on learning about AI power with pgvector and Retrieval-Augmented Generation can be found here:

https://vyruss.org/computing/slides/postgresedi_ragtime_with_postgres.pdf

cc @PostgresEDI

#postgres #ai #aiops #llmops #llm #aiengineering #programming #opensource #tech #dev #devcommunity

If you need some distraction this Christmas Day, you're near Leicester or Loughborough and money is tight, then the Great Central Railway are running some special steam services where they're insisting that you only pay what you can afford. https://www.railadvent.co.uk/2025/12/leicestershire-railway-to-run-pay-what-you-can-afford-steam-train-service-this-christmas-day.html

Curious what to expect at @pgconfdev in 2026?
Tune in to a new #TalkingPostgres episode with @clairegiordano, featuring an interview with our co-organizer @melanieplageman. They cover what’s new for PGConf.dev 2026, how to strengthen your CFP submission, and the thoughtful (and sometimes creative!) ways we work to make PGConf.dev welcoming for newcomers and experienced community members alike.

🎧 Podcast: https://talkingpostgres.com/episodes/what-postgres-developers-can-expect-from-pgconf-dev-with-melanie-plageman
📺 YouTube: https://www.youtube.com/watch?v=wHs10_qAtr0&list=PLixnExCn6lRrb_wV1yV9thFI1r7DOPhER

That’s a wrap on the first #PostgreSQL #Edinburgh #meetup! 🐘

Huge thanks to @intrbiz for the talk, @pgEdgeDistributedPostgres for the 🍕, and UoE for the venue.

Slides:
🔹 PG Tricks: https://nexteam.co.uk/files/talks/pg-tricks-postgresedi-meetup.pdf
🔹 RAGtime with #Postgres: https://vyruss.org/computing/slides/postgresedi_ragtime_with_postgres.pdf

We return Feb 12th and need speakers! 🎤 DM/reply if you have a talk idea or feedback!

Happy holidays! 🎄

#TechMeetup #OpenSource #Database

Setting up...

Do you really need tsvector column? – select * from depesz; https://www.depesz.com/2025/11/03/do-you-really-need-tsvector-column/ #postgres