Top all-time · #4038
Maybe a -> Blog
Personal blog · rachbelaid.comdataprogramming
Maybe a -> Blog is a personal blog at rachbelaid.com about data and programming. Since 2016, 19 different Hacker News readers have linked it 22 times, most often “Postgres full-text search is Good Enough (2015)”. The last post was in 2015, but the archive is still widely read.
Too few sampled comments (15) to say how often HN recommends it.?
Why HN links it
HN readers link this Postgres full-text search post as a reference for using Postgres instead of a separate search engine like Elasticsearch. Many commenters cite it in threads on search and databases.
Summarised by Claude from a sample of 15 HN comments that link here. Each comment is marked recommending, critical or neutral (citing without judging); how this works.
Most-linked posts?
- Postgres full-text search is Good Enough (2015)14 people · 14 mentions · first linked 2016-06-12
- Pome: Postgres monitoring dashboard2 people · 3 mentions · first linked 2016-01-05
What Hacker News says?
Anectodal note: A few years ago we added yet-another part to our product and, whilst ES worked "okay", we got a bit weary of ES due to "some issues" (some bug in the architecture keeping things not perfect in sync, certain queries with "joins" of types taking long, demand on HW due to the size of database, no proper multi-node setup due to $$$ and time constraint, etc.; small things piling up over time). Bright idea…
Comment linking /postgres-full-text-search-is-good-enough/
on “Postgres Full-Text Search: A search engine in a database”Submitted Introduction to PostgreSQL physical storage as a story · 256 points
HN discussionThis has been around for a while but it's a great summary of what Postgres can do: http://rachbelaid.com/postgres-full-text-search-is-good-enou... In my experience performance is great if you're just doing text search, but if you combine that with other operators in the same SELECT it can be much slower than Elasticsearch since in many of those cases Postgres needs to fall back to a full table scan.
Comment linking /postgres-full-text-search-is-good-enough/
on “PostgreSQL 9.6 Released”Submitted Postgres full-text search is Good Enough (2015) as a story · 166 points
HN discussionhttp://rachbelaid.com/postgres-full-text-search-is-good-enou...
Comment linking /postgres-full-text-search-is-good-enough/
on “Is PostgreSQL good enough?”Submitted Pome: Postgres monitoring dashboard as a story · 27 points
HN discussionIf you only need modest search functionality and you don't want to manage another service/system, Postgres full-text search may be for you. http://rachbelaid.com/postgres-full-text-search-is-good-enou... I read this article about 6 years ago and after an afternoon I added full-text search to the app I worked on at the time. 6 years later, it's still the only search they use. This small tool already built into postgr…
Comment linking /postgres-full-text-search-is-good-enough/
on “Postgres full-text search: A search engine in a database (2021)”Submitted Postgres full-text search is Good Enough (2015) as a story · 3 points
HN discussionPostgreSQL Full-text search is good enough. Also recently in PG12 they did many perf optimizations (Table Partitioning, Indexing, Vacuum) which will help in this regard. http://rachbelaid.com/postgres-full-text-search-is-good-enou... Text search functions - https://www.postgresql.org/docs/12/functions-textsearch.html
Comment linking /postgres-full-text-search-is-good-enough/
on “AWS Elasticsearch: a fundamentally-flawed offering”Submitted Postgres full-text search is Good Enough as a story · 2 points
HN discussionOut of curiosity —- have you looked at using Postgresql’s full text search functionality to implement your search engine (e.g. [1])? If so, what do you get out of the combination of Postgres + Elasticsearch that you chose it over just the Postgres full text search? [1] http://rachbelaid.com/postgres-full-text-search-is-good-enou...
Comment linking /postgres-full-text-search-is-good-enough/
on “Toshi: An Elasticsearch competitor written in Rust”Submitted Handling concurrent INSERT with SQLAlchemy (2015) as a story · 2 points
HN discussionWhat other examples are there of "single dependency stacks"? This article is really about the versatility and reliability of postgres. And I'm all in agreement. Reminiscent of: https://www.craigkerstiens.com/2017/04/30/why-postgres-five-... https://webapp.io/blog/postgres-is-the-answer/ http://rachbelaid.com/postgres-full-text-search-is-good-enou... http://boringtechnology.club/ As much as HN could lead you astray w…
Comment linking /postgres-full-text-search-is-good-enough/
on “Single dependency stacks”Just use Postgres fulltext Search, its good enough http://rachbelaid.com/postgres-full-text-search-is-good-enou...
Comment linking /postgres-full-text-search-is-good-enough/
on “Ask HN: Books about full text search?”I probably wouldn't migrate a project, but I switched my default db to PostgreSQL after seeing the many ways MySQL can silently screw up data. Truncating strings, truncating numbers, allowing NULLs in a NOT NULL, etc. Much (all?) of this can be fixed with settings these days: https://dev.mysql.com/doc/refman/5.7/en/constraint-invalid-d... PostgreSQL has a hard bias toward correctness. If you give it invalid data, it…
Comment linking /postgres-full-text-search-is-good-enough/
on “Anyone made the jump from MySQL to PostreSQL? It is worth it?”> Why would one use Algolia over Postgres's built in text search features? Ex: http://rachbelaid.com/postgres-full-text-search-is-good-enou... . Postgres built-in search features are really for large document searching -- we've tried using it for indexing e.g. an array of tags for auto-complete and the search times were in the ~500ms+ range, as a matter of fact the non-indexed regex search was only slightly slower.…
Comment linking /postgres-full-text-search-is-good-enou..
on “Thoughts on Algolia vs. Solr and Elasticsearch”Why would one use Algolia over Postgres's built in text search features? Ex: http://rachbelaid.com/postgres-full-text-search-is-good-enou... I already have Postgres search queries running on the order of 1-3ms for large queries, basically faster than Algolia, with seemingly the same feature sets. I don't understand the value proposition over something like Postgres, for sites that already have Postgres databases. (A…
Comment linking /postgres-full-text-search-is-good-enough/
on “Thoughts on Algolia vs. Solr and Elasticsearch”SEEKING WORK - San Francisco - Senior Software Engineer Experienced Python developer with a good database knowledge, with experience in Ops and Javascript. - Programming: Python, Javascript, Go - Frameworks: Pyramid, SQLAlchemy, Django, React - Software: Nginx, Postgres, Redis - Experience: 10y - Experimenting with: Swift, Haskell, Elixir, Phoenix Download my resume and read more about me here: http://rachbelaid.com…
Comment linking /
on “Ask HN: Freelancer? Seeking freelancer? (January 2016)”Here the author. Glad and scare that this project reached the 1st page of HN. This project is at a very early stage but I had to release it at some stage. I wrote some explanation in the Readme [1] and in a blog post [2]. TL;DR: Pome aim to be very simple to deploy, opinionated and battery included tool to have a look at the health of your PG db. It's maybe not the case of anybody here but in my career, I have seen…
Comment linking /introducing-pome/
on “Pome – Postgres Metrics Dashboard Written in Go”Here the author. I understand your points, I wrote a bit about my personal motivation behind this project. http://rachbelaid.com/introducing-pome/ I also wrote within the readme about why wrote the project (context+goals), https://github.com/rach/pome#why-building-pome This project is not aimed to replace more advanced tool like collectd but to offer a basic all-in-one solution. I'm also not planning to support huge…
Comment linking /introducing-pome/
on “Pome – Postgres Metrics Dashboard Written in Go”Well... HN for one or Reddit, r/programming and r/webdev would probably be logical places to ask/discuss such things. As for web search, something like solr/elastic search or even just Postgres eg http://rachbelaid.com/postgres-full-text-search-is-good-enou... I used Postgres full text search (from Rails) and it was simple and easy to get going but never got beyond pilot stage so can't comment on longer term short c…
Comment linking /postgres-full-text-search-is-good-enough/
on “Notable web-sites for Software developers?”
