From 0cbb8205225d8f69ff3604b7d067fa96ce6b0c03 Mon Sep 17 00:00:00 2001 From: teodor Date: Mon, 5 Oct 2009 08:05:29 +0000 Subject: [PATCH] Update README --- README.plantuner | 39 +++++++++++++++++++++++---------------- 1 file changed, 23 insertions(+), 16 deletions(-) diff --git a/README.plantuner b/README.plantuner index 16aef5e..2d01f8e 100644 --- a/README.plantuner +++ b/README.plantuner @@ -1,30 +1,38 @@ Plantuner - enable planner hints -contrib/plantuner is a contribution module for PostgreSQL 8.4+, which enable -planner hints. + contrib/plantuner is a contribution module for PostgreSQL 8.4+, which + enable planner hints. -All work was done by Teodor Sigaev (teodor@sigaev.ru) and - Oleg Bartunov (oleg@sai.msu.su). + All work was done by Teodor Sigaev (teodor@sigaev.ru) and Oleg Bartunov + (oleg@sai.msu.su). + + Sponsor: Nomao project (http://www.nomao.com) -Sponsor: JFG Networks (www.jfg-networks.net) Motivation -It's very interesting to be able to control planner (provide hints), which is -currently impossible. This first version of plantuner provides a possibility to -hide specified indexes from PostgreSQL planner, so it will not use them. + Whether somebody think it's bad or not, but sometime it's very + interesting to be able to control planner (provide hints, which tells + optimizer to ignore its algorithm in part), which is currently + impossible in POstgreSQL. Oracle, for example, has over 120 hints, SQL + Server also provides hints. + + This first version of plantuner provides a possibility to hide + specified indexes from PostgreSQL planner, so it will not use them. + + There are many situation, when developer want to temporarily disable + specific index(es), without dropping them, or to instruct planner to + use specific index. -There are many situation, when developer want to temporarily disable specific -index(es), without dropping them, or to instruct planner to use specific index. Installation - * Get latest source of plantuner from CVS Repository - * gmake && gmake install && gmake installcheck + * Get latest source of plantuner from CVS Repository + * gmake && gmake install && gmake installcheck Usage -To enable the module you can either load shared library 'plantuner' in psql -session or specify 'shared_preload_libraries' option in postgresql.conf. - + To enable the module you can either load shared library 'plantuner' in + psql session or specify 'shared_preload_libraries' option in + postgresql.conf. =# LOAD 'plantuner'; =# create table test(id int); =# create index id_idx on test(id); @@ -62,4 +70,3 @@ Indexes: Seq Scan on test (cost=10000000000.00..10000000040.00 rows=12 width=4) Filter: (id = 1) (2 rows) - -- 2.46.1