Postgres Pro
Downloads
Home   >   mailing lists

Re: [NOVICE] WHERE clause not used when index is used - Mailing list pgsql-hackers

From Peter Geoghegan
Subject Re: [NOVICE] WHERE clause not used when index is used
Date
Msg-id CAM3SWZRYVrcCvRv5hsoinwkkexRUvsXMp=WrZjkDiQ-FZt8Lsg@mail.gmail.com
Whole thread Raw
In response to Re: [NOVICE] WHERE clause not used when index is used  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
Tree view 
On Thu, Mar 3, 2016 at 2:07 AM, Simon Riggs <simon@2ndquadrant.com> wrote:
> Later, I will add the tests we discovered here to index scans, so that
> further optimization work is more easily possible.

Please do.

I would like to start testing the B-Tree code more exhaustively by
adding a test suite to amcheck. This test suite would indirectly test
external sorting, B-Tree page deletion, edge-cases with very large
IndexTuples, etc.

Ideas for good areas of the B-Tree code to add tests for are welcome.

-- 
Peter Geoghegan

pgsql-hackers by date:

Previous
From: Robbie Harwood
Date:
Subject: Re: [PATCH v6] GSSAPI encryption support
Next
From: Stephen Frost
Date:
Subject: Re: [PATCH v6] GSSAPI encryption support