PostgreSQL index Correlation with UPDATE

Here is a small example inspired by by this on HackerNews:

SELECT * FROM TABLE FOO WHERE ORGANIZATION_ID = 10 ORDER BY CREATED_AT LIMIT 10 OFFSET 0;

Postgres sorts by created_at using an index, but uses the filter on organization_id. This organization has a million rows... without the order, the query runs in ms. In order, in seconds/minutes.

I did the same test on SQLServer and SQLite, they executed the query correctly, using the correct index. I've never created an …

correlation database filter hackernews index limit order organization postgres postgresql query select sql update