Re: Re: Adding additional index causes 20,000x slowdown for certain select queries - postgres 9.0.3

From: Claudio Freire <klaussfreire(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Re: Adding additional index causes 20,000x slowdown for certain select queries - postgres 9.0.3
Date: 2011-03-16 18:39:26
Message-ID: AANLkTik3SfZih19i2svVX7BCxEOYkaGDGyzkovRrnZj3@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wed, Mar 16, 2011 at 3:34 PM, Shaun Thomas <sthomas(at)peak6(dot)com> wrote:
> If not, it seems like a valid configurable. We set our random_page_cost to
> 1.5 once the DB was backed by NVRAM. I could see that somehow influencing
> precedence of a backwards index scan. But even then, SSDs and their ilk
> react more like RAM than even a large RAID... so should there be a setting
> that passes such useful info to the planner?

Forgive the naive question...
but...

Aren't all index scans, forward or backward, random IO?

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Derrick Rice 2011-03-16 19:40:55 Updating histogram_bounds after a delete
Previous Message Shaun Thomas 2011-03-16 18:34:52 Re: Re: Adding additional index causes 20,000x slowdown for certain select queries - postgres 9.0.3