[PERFORM] tip: faster sorting for proximity queries by using cube_distance()

2007-02-07 Thread Mark Stosberg
Hello, I wanted to share something else I learned in my proximity search work. One my requirements is to order by the distance that matches are found from the center point. When did this using earth_distance(), the benefit of the earth_box() technique over the old geo_distance became minimal as

Re: [PERFORM] Help Needed

2007-02-07 Thread Richard Huxton
Muruganantham M wrote: Hi, We are developing one website using ChessD in red hat environment. ChessD is a open source which requires Postgres as its back end. When we tried to install ChessD we got the error Missing postgresql/libpq-fe.h, is libpq-dev installed?. Have you tried looking for

[PERFORM] Help Needed

2007-02-07 Thread Muruganantham M
Hi, We are developing one website using ChessD in red hat environment. ChessD is a open source which requires Postgres as its back end. When we tried to install ChessD we got the error Missing postgresql/libpq-fe.h, is libpq-dev installed?. But this chess D is works fine in Debian and We need a