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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bryan Murphy <bmurphy1976(at)gmail(dot)com>
Cc: Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Help Me Understand Why I'm Getting a Bad Query Plan
Date: 2009-03-26 03:28:17
Message-ID: 12624.1238038097@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Bryan Murphy <bmurphy1976(at)gmail(dot)com> 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Bryan Murphy 2009-03-26 04:00:25 Re: Help Me Understand Why I'm Getting a Bad Query Plan
Previous Message Bryan Murphy 2009-03-26 03:19:13 Re: Help Me Understand Why I'm Getting a Bad Query Plan