Re: [SQL] GiST index question: performance

2007-03-06 Thread Peter Eisentraut
Steve Midgley wrote: my ISP that manages my Pg SQL server is (in my interests) concerned about installing anything non-standard (read: unstable) onto their server. I was able to get them to install your TSearch2 b/c it's been proven many times, but I'm hesitant to even bring up Q3C since it's

Re: [SQL] GiST index question: performance

2007-03-06 Thread Steve Midgley
Hi Peter, :) All my Pg code is written via (or handed to) an abstraction layer, and I actually write no functions or stored procedures at all. I write using Rails, so in this case it's a Ruby library called ActiveRecord which has a Postgres module that allows me to talk via

Re: [SQL] GiST index question: performance

2007-03-06 Thread Oleg Bartunov
On Tue, 6 Mar 2007, Steve Midgley wrote: Hi Peter, :) All my Pg code is written via (or handed to) an abstraction layer, and I actually write no functions or stored procedures at all. I write using Rails, so in this case it's a Ruby library called ActiveRecord which has a Postgres module

[SQL] GiST index question: performance

2007-03-05 Thread Steve Midgley
Hi, First off, can I say how much I love GiST? It's already solved a few problems for me that seemed impossible to solve in real-time queries. Thanks to everyone who works on that project! I'm developing a geographic index based on a set of zip code boundaries. Points of interest (POI) will

Re: [SQL] GiST index question: performance

2007-03-05 Thread Oleg Bartunov
On Mon, 5 Mar 2007, Steve Midgley wrote: Hi, First off, can I say how much I love GiST? It's already solved a few problems for me that seemed impossible to solve in real-time queries. Thanks to everyone who works on that project! Thanks, Steve ! I'm developing a geographic index based

Re: [SQL] GiST index question: performance

2007-03-05 Thread Steve Midgley
Thanks Oleg - very interesting stuff you are working on. You may recall I exchanged emails with you on openfts a little while ago - my ISP that manages my Pg SQL server is (in my interests) concerned about installing anything non-standard (read: unstable) onto their server. I was able to get