[PERFORM] OT: Data structure design question: How do they count so fast?

2006-04-08 Thread Brendan Duddridge
Hi,First of all, the reason I'm posting on the PostgreSQL Performance list is we have a performance issue with one of our applications and it's related to the speed at which PostgreSQL can do counts. But it's also related to the data structure we've designed to develop our comparison shopping engin

Re: [PERFORM] Indexes with descending date columns

2006-04-08 Thread Bruce Momjian
Jim C. Nasby wrote: > On Wed, Mar 29, 2006 at 12:52:31PM +0200, Theo Kramer wrote: > > On Fri, 2006-03-24 at 12:21, Jim C. Nasby wrote: > > > On Thu, Mar 23, 2006 at 01:09:49PM +0200, Theo Kramer wrote: > > > > ii If no to i, is it feasible to extend PostgreSQL to allow traversing > > > >an ind