Re: Re: [GENERAL] contrib/plantuner - enable PostgreSQL planner hints - Mailing list pgsql-hackers

From Cédric Villemain
Subject Re: Re: [GENERAL] contrib/plantuner - enable PostgreSQL planner hints
Date
Msg-id p2ie94e14cd1004290135p98ec0c08j36cee13f79bc99f4@mail.gmail.com
Whole thread Raw
In response to Re: Re: [GENERAL] contrib/plantuner - enable PostgreSQL planner hints  (Jaime Casanova <jcasanov@systemguards.com.ec>)
List pgsql-hackers
2010/4/29 Jaime Casanova <jcasanov@systemguards.com.ec>:
> 2009/10/12 Teodor Sigaev <teodor@sigaev.ru>:
>>
>>
>>> 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 the slave so we can  advice to disable those
> indexes there

if we know that, can the planner now that too ?

>
> the only problem is that seems like we can't put
> "plantuner.forbid_index='a_hash_index'" on postgresql.conf ala
> auto_explain, that could make this better
>
> --
> Atentamente,
> Jaime Casanova
> Soporte y capacitación de PostgreSQL
> Asesoría y desarrollo de sistemas
> Guayaquil - Ecuador
> Cel. +59387171157
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
>



--
Cédric Villemain


pgsql-hackers by date:

Previous
From: Mike Fowler
Date:
Subject: Re: XML Todo List
Next
From: Simon Riggs
Date:
Subject: Re: Toast rel options