Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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

pgsql-hackers by date

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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group