2010/4/29 Jaime Casanova :
> 2009/10/12 Teodor Sigaev :
>>
>>
>>> Are you planning to submit this as a /contrib module?
>>
>> I haven't objections to do that, we don't planned that because we know
>> sceptical
>> relation of community to hints :)
>
> this could be very useful now that we have HS an
2009/10/12 Teodor Sigaev :
>
>
>> Are you planning to submit this as a /contrib module?
>
> I haven't objections to do that, we don't planned that because we know
> sceptical
> relation of community to hints :)
this could be very useful now that we have HS and we aren't able to
use hash indexes on
On Tue, 13 Oct 2009, Robert Haas wrote:
An exhaustive dump of everything the planner has considered is going to
be a LOT of data, and I don't really want to have to set up a graphical
visualization tool every time I have a planning question. I am a
command-line kind of guy...
Wouldn't this
On Tue, Oct 13, 2009 at 10:14 AM, Kevin Grittner
wrote:
> Robert Haas wrote:
>
>> I sometimes want to know what the planner thinks the cost of some
>> plan other than the one actually selected would be.
>
> Another DBMS I used for years had a way to turn on an *extremely*
> verbose mode for their
On Tue, 2009-10-13 at 11:26 -0700, Jeff Davis wrote:
> On Tue, 2009-10-13 at 09:14 -0500, Kevin Grittner wrote:
> > Now that we can generate EXPLAIN output in more structured formats,
> > perhaps we could think about adding an "extremely verbose" mode where
> > the planner would "think out loud" as
On Tue, 2009-10-13 at 09:14 -0500, Kevin Grittner wrote:
> Now that we can generate EXPLAIN output in more structured formats,
> perhaps we could think about adding an "extremely verbose" mode where
> the planner would "think out loud" as a whole separate section from
> where we show the chosen pla
Kevin Grittner wrote:
> Robert Haas wrote:
>
> > I sometimes want to know what the planner thinks the cost of some
> > plan other than the one actually selected would be.
>
> Another DBMS I used for years had a way to turn on an *extremely*
> verbose mode for their planner; it showed everythin
Robert Haas wrote:
> I sometimes want to know what the planner thinks the cost of some
> plan other than the one actually selected would be.
Another DBMS I used for years had a way to turn on an *extremely*
verbose mode for their planner; it showed everything it considered
with its related cos
On Mon, Oct 12, 2009 at 11:31:24AM -0400, Robert Haas wrote:
> 2009/10/12 Teodor Sigaev :
> >> Are you planning to submit this as a /contrib module?
> >
> > I haven't objections to do that, we don't planned that because we
> > know sceptical relation of community to hints :)
>
> I think it would b
2009/10/12 Teodor Sigaev :
>> Are you planning to submit this as a /contrib module?
>
> I haven't objections to do that, we don't planned that because we know
> sceptical
> relation of community to hints :)
I think it would be pretty useful to have some additional knobs to
poke at the planner. I
Teodor Sigaev wrote:
>
>
> > Are you planning to submit this as a /contrib module?
>
> I haven't objections to do that, we don't planned that because we know
> sceptical
> relation of community to hints :)
Well, the nice thing about this patch is that the hints are mostly
external to the backe
Are you planning to submit this as a /contrib module?
I haven't objections to do that, we don't planned that because we know sceptical
relation of community to hints :)
--
Teodor Sigaev E-mail: teo...@sigaev.ru
Oleg Bartunov wrote:
> =# set enable_seqscan=off;
> =# set plantuner.forbid_index='id_idx2';
The genius of this module is the line above -- a more fine-grained way
to control the optimizer, with specific index disabling.
> =# explain select id from test where id=1;
>
13 matches
Mail list logo