support extending indexscan,heapscan and customizing plan
От | zhuxiang |
---|---|
Тема | support extending indexscan,heapscan and customizing plan |
Дата | |
Msg-id | 000c01c9495f$573b61c0$0f8e3e0a@yahoo.ali.com обсуждение исходный текст |
Список | pgsql-hackers |
<div class="Section1" style="layout-grid:15.6pt"><p class="MsoNormal"><font face="Arial" size="1"><span lang="EN-US" style="font-size: 9.0pt;font-family:Arial">Hi,</span></font><p class="MsoNormal"><font face="Arial" size="1"><span lang="EN-US" style="font-size: 9.0pt;font-family:Arial"> we currently want to employ PG and Gin Index for light-weight full text search engine. however,</span></font><p class="MsoNormal"><font face="Arial" size="1"><span lang="EN-US" style="font-size: 9.0pt;font-family:Arial">we encounter a problem that Gin Index is not quick enough for relevence, because it must</span></font><pclass="MsoNormal"><font face="Arial" size="1"><span lang="EN-US" style="font-size: 9.0pt;font-family:Arial">scan all heaptuples which statisfy the condition, then invoke ts_rank to compute the rank of tuple.</span></font><p class="MsoNormal"><font face="Arial" size="1"><span lang="EN-US" style="font-size: 9.0pt;font-family:Arial">an idea comes to us: add some foundamental ranking features to the Gin index structure;</span></font><pclass="MsoNormal"><font face="Arial" size="1"><span lang="EN-US" style="font-size: 9.0pt;font-family:Arial">then we can find the most relevance tuples just from index, which result in a problem that we must</span></font><p class="MsoNormal"><font face="Arial" size="1"><span lang="EN-US" style="font-size: 9.0pt;font-family:Arial">add a type of indexscan and heapscan,customize plan. but PG don't support the behaviors,.</span></font><pclass="MsoNormal"><font face="Arial" size="1"><span lang="EN-US" style="font-size: 9.0pt;font-family:Arial">As far as I know, oracle support customizing plan. My question is how can i slove it, and whetherPG </span></font><p class="MsoNormal"><font face="Arial" size="1"><span lang="EN-US" style="font-size: 9.0pt;font-family:Arial">will support extending indexscan and heapscan,customizing plan in future.</span></font><p class="MsoNormal"><fontface="Arial" size="1"><span lang="EN-US" style="font-size: 9.0pt;font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="1"><span lang="EN-US" style="font-size: 9.0pt;font-family:Arial">Thanks</span></font><p class="MsoNormal"><font face="Arial" size="1"><span lang="EN-US" style="font-size: 9.0pt;font-family:Arial"> --zhuxiang</span></font><pclass="MsoNormal"><font face="Arial" size="1"><span lang="EN-US" style="font-size: 9.0pt;font-family:Arial"> Yahoo! CN</span></font><pclass="MsoNormal"><font face="Arial" size="1"><span lang="EN-US" style="font-size: 9.0pt;font-family:Arial"> </span></font></div>
В списке pgsql-hackers по дате отправления: