Postgres Pro
Downloads
Home   >   mailing lists

Re: Odd behavior with indices - Mailing list pgsql-performance

From Merlin Moncure
Subject Re: Odd behavior with indices
Date
Msg-id CAHyXU0w4-aETfh65td-N=mds2vNgSh2eUoqLiATHqDFVEONbLA@mail.gmail.com
Whole thread Raw
In response to Re: Odd behavior with indices  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Odd behavior with indices
List pgsql-performance
Tree view 
On Mon, Feb 29, 2016 at 12:47 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> FWIW, PG >= 9.5 will ignore a LIMIT 1 inside an EXISTS, so that you get
> the same plan with or without it.  But that does act as an optimization
> fence in earlier releases.

Does 'offset 0' still work as it did?

merlin

pgsql-performance by date:

Previous
From: Jehan-Guillaume de Rorthais
Date:
Subject: Re: [ADMIN] autovacuum disk IO
Next
From: Tory M Blue
Date:
Subject: Clarification on using pg_upgrade