If you use PostgreSQL in your business, this is a chance to addĪ basic capability that may help you in all kinds of ways you don'tĮxpect. I am looking for sponsors in the $5K to $10K range to complete this You think I am kidding: we had a patch for KNN searching ready for theĩ.0 release, but it wasn't reviewed in time, so we had to wait all the Through more QA/QC, it'll never get into PostgreSQL proper.
However, there is a problem: unless the patch is reviewed and goes Which provides quad-tree and kd-tree indexes. Thanks to the sponsorship of Michigan Technological University, we now Paul's PostGIS newsgroup note about seeking funding for faster GIST indexes, work done so far on SP-GIST and call for further action is rebroadcast in it's entirety here. I think one of PostgreSQL's greatest strength is its extensible index API. These spring to life in PostgreSQL 9.2 and think it will help to further push the envelope of where PostgreSQL can go as a defacto platformįor cutting-edge technology and scientific research. ,ltree, tsearch, and hstore, I'm pretty excited about these patches and other GIST and general index enhancements and there potential use in GIST dependent extensions.
What it provides specifically for PostGIS is summarized in Paul's call for action noted below. PGCon 2011: SP-GiST - a new indexing infrastructure for PostgreSQL What the SP-GIST patch will provide in terms of performance and speed was outlined in It's one of those short-comings among the trillion others I have that I have learned to accept will probably never change. I have to admit to being very clueless when it comes to the innards of index implementations so don't ask me any technical details. PostGIS, trigrams, ltree, pgsphere, hstore, full-text search to name a few.Īnother is a recent one just committed by Alexander Korotkov which I just recently found out about on New node splitting algorithm for GIST and admit I don't know enough about to judge. For those who don't know Teodor and Oleg, they are the great fellows that brought us many other GiST and GIN goodnesses that many specialty PostgreSQLĮxtensions enjoy - e.g.
Teodor Sigaev and Oleg Bartunov whose basic technique is described in SP-GiST: An Extensible Database Index for Supporting Space Partitioning Trees. One is a patch for possible inclusion in PostgreSQL 9.2 called SP-GiST, Space-Partitioned GiST created by This is about improvements to GIST indexes that I hope to see in PostgreSQL 9.2.
0 kommentar(er)
