Re: Queries 15 times slower on 8.1 beta 2 than on 8.0 - Mailing list pgsql-performance

From Jean-Pierre Pelletier
Subject Re: Queries 15 times slower on 8.1 beta 2 than on 8.0
Date
Msg-id BAYC1-PASMTP0421C246AB993A0ED6542B95970@CEZ.ICE
Whole thread Raw
In response to Queries 15 times slower on 8.1 beta 2 than on 8.0  ("Jean-Pierre Pelletier" <pelletier_32@sympatico.ca>)
List pgsql-performance
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


pgsql-performance by date:

Previous
From: "Gavin M. Roy"
Date:
Subject: Re: Queries 15 times slower on 8.1 beta 2 than on 8.0
Next
From: John Arbash Meinel
Date:
Subject: Re: Queries 15 times slower on 8.1 beta 2 than on 8.0