Re: LIMIT OFFSET with DB view vs plain SQL

Raj Gandhi wrote:
> I’m using LIMIT offset with DB view. Looks like query planner is applying the LIMIT for DB view at the end after
processingall rows.
 
> When running same SQL that was used to create the DB view, LIMIT is applied earlier so the query is much faster.
>  
> Explain plan using DB view
> https://explain.depesz.com/s/gzjQ
>  
> Explain plan using raw SQL
> https://explain.depesz.com/s/KgwO
>  
> In both tests LIMIT was 100 with offset  = 0.
> Is there any way to force DB view to apply limit earlier?

Please show

- the view definition
- the query on the view
- the query without the view

Yours,
Laurenz Albe
-- 
+43-670-6056265
Cybertec Schönig & Schönig GmbH
Gröhrmühlgasse 26, A-2700 Wiener Neustadt
Web: https://www.cybertec-postgresql.com