Re: How to influence the planner - Mailing list pgsql-sql

From Richard Huxton
Subject Re: How to influence the planner
Date
Msg-id 46D93F0E.5070404@archonet.com
Whole thread Raw
In response to Re: How to influence the planner  (Richard Ray <rray@mstc.state.ms.us>)
List pgsql-sql
Richard Ray wrote:
> 
> When is enable_seqscan = off appropriate

Never(*)

It's not for normal usage, the various enable_xxx settings do let you 
experiment with different options if you think the planner is making a 
mistake.

(*) OK, sooner or later, if you have enough systems and enough 
performance-critical queries then you might want to use it in 
production. But only if you really know what you're doing and you've 
exhausted you're other options.

--   Richard Huxton  Archonet Ltd


pgsql-sql by date:

Previous
From: Richard Ray
Date:
Subject: Re: How to influence the planner
Next
From: Dmitry Turin
Date:
Subject: Re: Request into several DBMS simultaneously on DDL and DML