Re:Do you need Redis? PostgreSQL does queuing, locking, and ...
by machine_coffee on Monday November 04, 2024 @03:29AM
(#42039635)
This is the best response so far. Session churn creates lots of db activity but lots of it is of low business value. Better to offload to a separate process.
Also session data is often Blobs which db's don't process as efficiently as columnar data.
After the significant success of the first conversion, we've been working to convert all the rest of our apps.
And no, host language data structures aren't useful because they aren't in shared memory between all the worker processes, and even if we found a module that implemented them in shared memory, we like to be able to preserve the sessions across a host restart, and then we'd need a process to save the data structures to disk and load them back, and by the time we did that we'd have just reinvented redis.