Re: Runtime variations during day

From: Vick Khera <vivek(at)khera(dot)org>
To: Kevin Grittner <kgrittn(at)ymail(dot)com>
Cc: Carlos Henrique Reimer <carlos(dot)reimer(at)opendb(dot)com(dot)br>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Runtime variations during day
Date: 2013-02-14 13:31:19
Message-ID: CALd+dcfgFSMfesood1_DfD60KxnKq0Am5j=RSTaY01EW1ehk=A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Feb 13, 2013 at 4:35 PM, Kevin Grittner <kgrittn(at)ymail(dot)com> wrote:

> seq_page_cost = 0.1
> random_page_cost = 0.1
>

Is there any gain in setting these to the same low value, as it would to
leave them both at 4? I thought they are just relative numbers to each
other. And unless you're on SSD, these numbers seem way too low, and
probably shouldn't be the same.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2013-02-14 14:10:54 Re: Query becomes slow when written as view
Previous Message Jan Strube 2013-02-14 13:23:19 Query becomes slow when written as view