Re: Runtime variations during day - Mailing list pgsql-general

From Vick Khera
Subject Re: Runtime variations during day
Date
Msg-id CALd+dcfgFSMfesood1_DfD60KxnKq0Am5j=RSTaY01EW1ehk=A@mail.gmail.com
Whole thread Raw
In response to Re: Runtime variations during day  (Kevin Grittner <kgrittn@ymail.com>)
Responses Re: Runtime variations during day  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-general
On Wed, Feb 13, 2013 at 4:35 PM, Kevin Grittner <kgrittn@ymail.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.

pgsql-general by date:

Previous
From: Jan Strube
Date:
Subject: Query becomes slow when written as view
Next
From: Merlin Moncure
Date:
Subject: Re: Query becomes slow when written as view