Postgres Pro
Downloads
Home   >   mailing lists

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

From Robert Haas
Subject Re: Help Me Understand Why I'm Getting a Bad Query Plan
Date
Msg-id 603c8f070903250640h775d4201w580b365ccf1669cb@mail.gmail.com
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 
On Tue, Mar 24, 2009 at 11:43 PM, Bryan Murphy <bmurphy1976@gmail.com> wrote:
> Looking through our configuration one more time, I see that at some
> point I set random_page_cost to 2.0, but I don't see any other changes
> to query planner settings from their default values.

You don't by any chance have enable_<something> set to "off", do you?

...Robert

pgsql-performance by date:

Previous
From: Jerry Champlin
Date:
Subject: Re: Raid 10 chunksize
Next
From: Scott Carey
Date:
Subject: Re: Raid 10 chunksize