+ pgsql-performance On Thu, Mar 28, 2019 at 6:41 PM Raj Gandhi <raj01gan...@gmail.com> wrote:
> Hi everyone, > > > > I’m using LIMIT offset with DB view. Looks like query planner is applying > the LIMIT for DB view at the end after processing all 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? > > > > Thanks, > > Raj >
