> To give you some perspective on the size of the dataset and the
> performance level we are hitting, here are some "good" results based on
> some explains:
Before Tom jumps in taking all the fun out of trying to solve it...
The estimates in the slow queries seem perfectly reasonable. In fact,
Hi All,
I'm sure some of you know me from previous questions on other lists,
but this one has myself and Marc completely stumped. We've got a
database that has about 89 Million rows, under PostgreSQL 7.3.3 on a
dual PIII 1.2 with 4 GBytes of RAM on a 5 disk RAID 5 array. The dataset
itself is ab