Re: [GENERAL] Query performance strangeness..

2007-07-19 Thread Steve Spicklemire
Hi Richard, On Jul 19, 2007, at 12:49 AM, Richard Huxton wrote: Steve Spicklemire wrote: I also have a function get_cem_for_directBurial(personid) that is expensive to call, but it's also indexed, so I hoped that the index would normally be used (essentially as a cache). It returns

[GENERAL] Query performance strangeness..

2007-07-18 Thread Steve Spicklemire
Hi Folks, I'm new to this list, but I've been using postgresql for a few years. In general I've been able to figure things out by reading various docs. I've hit something now that I haven't been able to sort out at all. It may be that there's some document that explains all this... if