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

From: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: [GENERAL] contrib/plantuner - enable PostgreSQL planner hints
Date: 2009-10-09 19:04:11
Message-ID: Pine.LNX.4.64.0910092301440.6801@sn.sai.msu.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

On Fri, 9 Oct 2009, Bruce Momjian wrote:

> 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.
>
.................
> Are you planning to submit this as a /contrib module?

No plan yet.

Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru)
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mike Christensen 2009-10-09 19:14:34 Re: Best data type to use for sales tax percent
Previous Message Andrew Gould 2009-10-09 19:03:38 Re: interface for "non-SQL people"

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2009-10-09 19:04:59 Re: Concurrency testing
Previous Message Markus Wanner 2009-10-09 18:46:39 Re: Concurrency testing