Top
Best
New

Posted by turtles3 9 hours ago

It's 2026, Just Use Postgres(www.tigerdata.com)
470 points | 284 commentspage 4
ddtaylor 8 hours ago|
I made the switch from MySQL to postgres a few years ago I didn't really understand what everyone was excited about before I made the switch. I haven't used MySQL since and I think postgres provides everything I need the only thing that I ever snarl at is how many dials and knobs and options there are that's not a bad thing!
trueno 8 hours ago|
> the only thing that I ever snarl at is how many dials and knobs and options there are that's not a bad thing!

yea this is me. postgres is actually insane for how much is offered at checks notes free.99.

_however_ we are probably due for like. I don't know a happy configurator type tool that has reasonable presets and a nice user friendly config tool that helps people get going without sidequesting for a year on devops/dbadmin expertise. that isn't even a favored outcome imo, you just get pretty lukewarm postgres-deployers who are probably missing a bunch of important settings/flags. my team mates would probably shit themselves in the face of postgres configs currently, they are absolute rats in the code but good and proper deployment of postgres is just a whole other career-arc they haven't journeyed and a _lot_ of organizations don't always have a devops/dbadmin type guy readily available any time you want to scrap together an app who's just going to wait for your signal to deploy for you. or said devops/dbadmin guy is just.. one guy and he's supporting 500 other things. not saying the absence/failing to scale teams with such personnel is right, it's just the reality and being up against workplace politics and making the case to convince orgs to hire a bigger team of devops/dbadmin guys involves a lot of shitty meetings and political prowess that is typically beyond an engineers set of capabilities, at least below the senior level. any engineer can figure out how to deploy postgres to something, but are they doing it in a way that makes an orgs security/infra guys happy? probably not. are they prepared to handle weird storage scenarios (log or temp space filling grinding server to a halt) and understand the weird and robust ways to manage a deployment? probably not.

getnormality 4 hours ago||
How does Postgres stack up against columnar databases like Vertica and DuckDB for analytical queries?
direwolf20 4 hours ago|
Not great. It works but the performance isn't ideal for this case. Still the advice is sound. You can build a new analytics system when you're doing enough analytical queries on enough data to bog down the primary system.
asdev 9 hours ago||
probably not many Firebase users here but I love Firebase's Firestore
oulipo2 8 hours ago|
It's very bad to search stuff, or have structured database, also it costs a lot
asdev 8 hours ago||
its dirt cheap and you can do basic search
storus 7 hours ago||
Pinecone allows hybrid search, merging dense and sparse vector embeddings that Postgres can't do AFAIK. That results in ~10% worse retrieval scores which might be the difference between making it in the business or not.
CharlieDigital 7 hours ago||
The lesson for me isn't "don't use Pinecone", but more like "did you already max out Postgres?"

In many cases, it is going to save you time by having less infra and one less risk while you're getting started. And if you find yourself outgrowing the capabilities of Pg then you look for an alternative.

RevEng 2 hours ago||
The article shows an example of hybrid search using RRF.
storus 2 hours ago||
With BM25 which has a far worse/non-generalizable performance than sparse embeddings Pinecone supports. Moreover you get a latency hit from RRF that makes it challenging to use for e.g. real-time multimodal chat agents.
program_whiz 8 hours ago||
Can anyone comment on whether postgres can replace full columnar DB? I see "full text search" but it feels like this is falling a little short of the full power of elastic -- but would be happy to be wrong (one less tech to remember).
fourseventy 8 hours ago||
There are several different plugins for postgres that do columnar tables, including the company TigerData which wrote this blog
irishcoffee 8 hours ago||
According to the LLM google search result, yes.

Have you looked into it?

dzonga 7 hours ago||
See my Comment on why hybrid db's like tigerDB(data) are good

- https://news.ycombinator.com/item?id=46876037

esafak 4 hours ago||
The only thing postgres lacks is a distributed option.
nubg 6 hours ago||
I think it's disgenious by the author to publish this article heavily edited by AI and not disclose it.
bastardoperator 8 hours ago||
I don't disagree, but I think big enterprises expect support, roadmaps, and the ability to ask for deliverables depending on the sale or context of the service.
sheerun 8 hours ago|
Postgres is king of its own, other solutions can be incorporated in it eventually by someone or some organization, that's it
More comments...