3 ms·
I think it makes a bunch of sense. As described in the earlier Postgres discussion around Uber's problem, it's not all that weird a use case -- just a difficul
by gamache 10y ago
I think it makes a bunch of sense. As described in the earlier Postgres discussion around Uber's problem, it's not all that weird a use case -- just a difficult one.
Summary: a table with around 50,000 rows that gets joined to other tables a lot, with one index per column, and that table receives ~500 writes a second, causing a "write amplification" because all the indexes need updating constantly.
It's not hard to imagine lots of other workloads involving patterns like that. Postgres has most simple use cases solved, so IMHO improving complex patterns like this is good for Postgres' future.