Yurgis Baykshtis wrote: I forgot to mention that you can actually create a true compound index using GiST, but it is quite complex and I havent actually done it. If you're interested in it, then you can check out the postgresql-hackers mail list or see teodor and oleg's GiST webpage. dave