Re: Odd behavior with indices

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Matheus de Oliveira <matioli(dot)matheus(at)gmail(dot)com>, joe meiring <josephmeiring(at)gmail(dot)com>, pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Odd behavior with indices
Date: 2016-03-04 22:18:34
Message-ID: CAHyXU0w4-aETfh65td-N=mds2vNgSh2eUoqLiATHqDFVEONbLA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Mon, Feb 29, 2016 at 12:47 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tory M Blue 2016-03-04 22:27:59 Clarification on using pg_upgrade
Previous Message Jehan-Guillaume de Rorthais 2016-03-04 17:28:02 Re: [ADMIN] autovacuum disk IO