Re: Re: [GENERAL] contrib/plantuner - enable PostgreSQL planner hints

From: Cédric Villemain <cedric(dot)villemain(dot)debian(at)gmail(dot)com>
To: Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec>
Cc: Teodor Sigaev <teodor(at)sigaev(dot)ru>, Bruce Momjian <bruce(at)momjian(dot)us>, Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Re: [GENERAL] contrib/plantuner - enable PostgreSQL planner hints
Date: 2010-04-29 08:35:25
Message-ID: p2ie94e14cd1004290135p98ec0c08j36cee13f79bc99f4@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

2010/4/29 Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec>:
> 2009/10/12 Teodor Sigaev <teodor(at)sigaev(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
>

--
Cédric Villemain

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Piotr Kublicki 2010-04-29 08:40:59 Re: Start-up script for few clusters: just add water?
Previous Message Magnus Hagander 2010-04-29 08:21:58 Re: Need magic that checks if a collumn contains values that CAN NOT be converted to Latin1

Browse pgsql-hackers by date

  From Date Subject
Next Message Mike Fowler 2010-04-29 08:40:28 Re: XML Todo List
Previous Message Simon Riggs 2010-04-29 08:18:57 Re: Re: [COMMITTERS] pgsql: Make CheckRequiredParameterValues() depend upon correct