Postgres not using correct indices for views.

"Thomas Rosenstein" <[email protected]>
Newsgroups gmane.comp.db.postgresql.performance
Message-ID <[email protected]>
Hi,

we have created restricted view for our tables, so that we can allow 
access to non-gdpr relevant data but hide everything else.

For exactly those views, the Query Planner uses the wrong indices, when 
executing exactly the same query, once it takes 0.1 s and on the views 
it takes nearly 18 sec (it does a full table scan, or uses the wrong 
indices).

Do we have to GRANT additional rights? I see it's using some indices, 
just not the correct ones!

Has anyone experienced the same issues? What can we do about that?

Thanks
BR
Thomas
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.