CharityAPI Blog company blog

Improving Postgres text search speed

by CharityAPI.org charityapi.org published 2022-08-134 min read

CharityAPI.org improved our Postgres response time so that searches initiated via our API were 760% faster without adding an additional tool like Elastic Search. This is how we did it.

Points

131

HN comments

57

Submissions

1

Cited by

0 commenters

Databases & DataSoftware Engineering2022

Related posts from the same era

Hosting SQLite databases on GitHub Pages or any static file hoster

Pphiresky20211,812 points314 commentscited by 26 details

I'm all-in on server-side SQLite

Fly.io Blog20221,353 points565 commentscited by 16 details

AWS announces forks of Elasticsearch and Kibana

AWS Blog20211,314 points935 comments details

Datomic is Free

DDatomic Blog20231,099 points368 commentscited by 5 details

My favourite API is a zipfile on the European Central Bank's website

csvbase Blog20231,024 points265 comments details

SQLite is not a toy database

Anton Zhiyanov2021986 points484 comments details