Re: index problems (again)

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: Geoff Winkless <pgsqladmin(at)geoff(dot)dj>
Cc: "Peter J(dot) Holzer" <hjp-pgsql(at)hjp(dot)at>, Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: index problems (again)
Date: 2016-03-13 06:46:27
Message-ID: CAMkU=1zr+GqdMyuZ5iF1omq82sw+VzNxvmOwL6EUL1y2fL9YMQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sat, Mar 12, 2016 at 1:00 PM, Geoff Winkless <pgsqladmin(at)geoff(dot)dj> wrote:
>
> As Jeff points out I'd have a much larger win in this instance by
> someone spending the time implementing skip index scans rather than
> messing with the planner :)

But I think the hardest part of implementing skip index scans would
probably be getting the planner to understand the cost of using them!
So one way or another, the planner has to get messed with.

Cheers,

Jeff

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alexander Farber 2016-03-13 10:07:09 "brew services list" shows postgresql as "started", but can not connect to it
Previous Message Jeff Janes 2016-03-13 06:40:10 Re: index problems (again)