Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Odd behavior with indices
Date
Msg-id 3108.1457135621@sss.pgh.pa.us
Whole thread Raw
In response to Re: Odd behavior with indices  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-performance
Tree view 
Merlin Moncure <mmoncure@gmail.com> writes:
> 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?

Yes.

            regards, tom lane

pgsql-performance by date:

Previous
From: Justin Pryzby
Date:
Subject: Re: Clarification on using pg_upgrade
Next
From: Tory M Blue
Date:
Subject: using stale statistics instead of current ones because stats collector is not responding