Postgres Pro
Downloads
Home   >   mailing lists

Postgres not using correct indices for views. - Mailing list pgsql-performance

From Thomas Rosenstein
Subject Postgres not using correct indices for views.
Date
Msg-id EC37F8FB-D294-409A-97CC-72C7A5A6CE42@creamfinance.com
Whole thread Raw
Responses Re: Postgres not using correct indices for views.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: improving windows functions performance
Next
From: Tom Lane
Date:
Subject: Re: Postgres not using correct indices for views.