Postgres Pro
Downloads
Home   >   mailing lists

Re: Help Me Understand Why I'm Getting a Bad Query Plan - Mailing list pgsql-performance

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
Whole thread Raw
In response to Re: Help Me Understand Why I'm Getting a Bad Query Plan  (Bryan Murphy <bmurphy1976@gmail.com>)
Responses Re: Help Me Understand Why I'm Getting a Bad Query Plan  (Bryan Murphy <bmurphy1976@gmail.com>)
List pgsql-performance
Tree view 
Bryan Murphy <bmurphy1976@gmail.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

pgsql-performance by date:

Previous
From: Bryan Murphy
Date:
Subject: Re: Help Me Understand Why I'm Getting a Bad Query Plan
Next
From: Bryan Murphy
Date:
Subject: Re: Help Me Understand Why I'm Getting a Bad Query Plan