23 ms·
Postgres is plenty fast. If you think it can only do 3 users or 800ms, you're doing something wrong.
by jayd16 5y ago
Postgres is plenty fast. If you think it can only do 3 users or 800ms, you're doing something wrong.
- x7777 5y agoIt is the blind claim of it being "plenty fast" that is resonated in this thread that I find problematic. The article describes how to implement queueing/app locks/pub sub, without providing any benchmarks on how the same implementations compare to redis under different loads. If you are using redis and you don't care about perf you are probably doing it wrong. If you are using postgres and you care about perf you are probably doing it wrong. "Probably" because context is key.
- mixmastamyk 5y agoPg is very fast. If it is slower it is because it does more and does it more safely. When not needed those things can be disabled. There are a number of tips about that in the discussion above, such as turning off logging of and partitioning a job table.