From: david@lang.hm
To: Csaba Nagy <nagy@ecircle-ag.com>
Cc: Bill Moran <wmoran@collaborativefusion.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: TB-sized databases
Date: Wed, 28 Nov 2007 07:03:26 -0800 (PST)
Message-ID: <Pine.LNX.4.64.0711280701370.4467@asgard> (raw)
In-Reply-To: <1196257702.31315.6.camel@PCD12478>
References: <4544e0330711260904g45d893a8ub1731e245aa8fc84@mail.gmail.com>
<474B1407.3090607@laotraesquina.com.ar>
<474B1B8C.1030505@gmail.com>
<4544e0330711271218h56ce4cc3p280a9fefff24583d@mail.gmail.com>
<1196197045.4246.1154.camel@ebony.site>
<474CA2FA.2020201@laotraesquina.com.ar>
<Pine.LNX.4.58.0711281248290.3731@aragorn.flymine.org>
<20071128082716.91bbad9c.wmoran@collaborativefusion.com>
<1196257702.31315.6.camel@PCD12478>
On Wed, 28 Nov 2007, Csaba Nagy wrote:
> On Wed, 2007-11-28 at 08:27 -0500, Bill Moran wrote:
>> Is there something wrong with:
>> set enable_seqscan = off
>> ?
>
> Nothing wrong with enable_seqscan = off except it is all or nothing type
> of thing... if you want the big table to never use seqscan, but a medium
> table which is joined in should use it, then what you do ? And setting
> enable_seqscan = off will actually not mean the planner can't use a
> sequential scan for the query if no other alternative exist. In any case
> it doesn't mean "please throw an error if you can't do this without a
> sequential scan".
>
> In fact an even more useful option would be to ask the planner to throw
> error if the expected cost exceeds a certain threshold...
and even better if the option can be overridden for a specific transaction
or connection. that way it can be set relativly low for normal operations,
but when you need to do an expensive query you can change it for that
query.
David Lang
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: david@lang.hm, nagy@ecircle-ag.com, wmoran@collaborativefusion.com
Subject: Re: TB-sized databases
In-Reply-To: <Pine.LNX.4.64.0711280701370.4467@asgard>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox