Skip to content

Plantuner

Plantuner, yeni bir PG projesi. Çevirmeyelim; doğrudan yazalım. Kullanalım, kullandıralım:


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.