blog/optimizing-postgre-sql-queries-with-multicolumn-and-partial-indexes

[giscus[bot]]

blog/optimizing-postgre-sql-queries-with-multicolumn-and-partial-indexes

I have an application that does asynchronous data processing, and at the core of the application are simulated queues in a PostgreSQL table. Each row in that queue represents atask and also contains the result of that task. You can imagine this table as a sort of multi-tenant where the rows belon...

https://filip-prochazka.com/blog/optimizing-postgre-sql-queries-with-multicolumn-and-partial-indexes