All indexes are there, and I've analyzed the three tables.
I turned off seq scan, the query plans became identical but the performance
was not better.
----- Original Message -----
Sent: Thursday, September 22, 2005 5:32 PM
Subject: Re: [PERFORM] Queries 15 times slower on 8.1 beta 2 than on 8.0

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

Reply via email to