From: pgsql-performance-ow...@postgresql.org
[mailto:pgsql-performance-ow...@postgresql.org] On Behalf Of Kai Sellgren
Sent: Thursday, January 09, 2014 4:37 PM
To: pgsql-performance@postgresql.org
Subject: [PERFORM] Issue with query scanning through all data even with indexes
Hi,
I have a query
Hi,
I have a query that has each field used in conditions + sort indexed, but
it scans through all data.
The query in question looks like:
http://pastie.org/8618562
I have each of those condition fields indexed:
NewsArticle.groupId
NewsArticle.sharedToCommunityIds
NewsArticle.sourceFilterIds
