What stood out to me the most was:
On Sep 22, 2005, at 2:20 PM, Jean-Pierre Pelletier wrote:
> -> Seq Scan on price p (cost=0.00..11317.75 rows=581475 width=4)
a) is the index there, b) have you analyzed, c) perhaps the planners
have different default values for when to use an index vrs a
seqscan... if you turn off seqscan, are the timings similar?
Gavin M. Roy
800 Pound Gorilla
gmr(at)ehpg(dot)net