Re: [NOVICE] WHERE clause not used when index is used

From: Tobias Florek <postgres(at)ibotty(dot)net>
To: Simon Riggs <simon(at)2ndQuadrant(dot)com>, "Simon Riggs" <simon(at)2ndquadrant(dot)com>
Cc: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Petr Jelinek" <petr(at)2ndquadrant(dot)com>, "Jeff Janes" <jeff(dot)janes(at)gmail(dot)com>, "pgsql-hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [NOVICE] WHERE clause not used when index is used
Date: 2016-03-03 10:11:13
Message-ID: 20160303101113.29596.12801@piano
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-novice

Hi,

> Reverted patch in HEAD and 9.5

Is there an ETA? We can't easily go back to 9.4 and while adding
additional conditions not to trigger this index only scan is possible,
but a little fragile.

Thank you for your work, btw. I was very surprised to find a bug in
PostgreSQL! I honestly still am.

Cheers,
Tobias Florek

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2016-03-03 10:13:33 Re: [NOVICE] WHERE clause not used when index is used
Previous Message Simon Riggs 2016-03-03 10:07:34 Re: [NOVICE] WHERE clause not used when index is used

Browse pgsql-novice by date

  From Date Subject
Next Message Simon Riggs 2016-03-03 10:13:33 Re: [NOVICE] WHERE clause not used when index is used
Previous Message Simon Riggs 2016-03-03 10:07:34 Re: [NOVICE] WHERE clause not used when index is used