On 2 Dec 2002 at 17:10, David F. Skoll wrote: > I've heard that a btree index performs badly in this situation.
As another poster has shown, it should be OK. I recently dealt with distributions simlar to your example. > Is a hash index appropriate? I've heard bad things about hash > indexes in PostgreSQL. No, don't use them. I didn't get any performance increase out of them. Does your experience show poor btree results? -- Dan Langille : http://www.langille.org/ ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
