Re: Help Me Understand Why I'm Getting a Bad Query Plan

From: Tom Lane
Subject: Re: Help Me Understand Why I'm Getting a Bad Query Plan
Date: ,
Msg-id: 12624.1238038097@sss.pgh.pa.us
(view: Whole thread, Raw)
In response to: Re: Help Me Understand Why I'm Getting a Bad Query Plan  (Bryan Murphy)
Responses: Re: Help Me Understand Why I'm Getting a Bad Query Plan  (Bryan Murphy)
List: pgsql-performance


Bryan Murphy <> writes:
> What I did was change seq_page_cost back to 1.0 and then changed
> random_page_cost to 0.5

[ squint... ]  It makes no physical sense for random_page_cost to be
less than seq_page_cost.  Please set them the same.

            regards, tom lane


pgsql-performance by date:

From: Mark Kirkwood
Date:
Subject: Re: Raid 10 chunksize
From: Dave Cramer
Date:
Subject: I have a fusion IO drive available for testing