Skip site navigation (1) Skip section navigation (2)

Re: Queries 15 times slower on 8.1 beta 2 than on 8.0

From: "Jean-Pierre Pelletier" <pelletier_32(at)sympatico(dot)ca>
To: "Gavin M(dot) Roy" <gmr(at)ehpg(dot)net>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Queries 15 times slower on 8.1 beta 2 than on 8.0
Date: 2005-09-22 21:38:40
Message-ID: BAYC1-PASMTP0421C246AB993A0ED6542B95970@CEZ.ICE (view raw or flat)
Thread:
Lists: 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 ----- 
  From: Gavin M. Roy 
  To: Jean-Pierre Pelletier 
  Cc: pgsql-performance(at)postgresql(dot)org 
  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
  gmr(at)ehpg(dot)net



In response to

pgsql-performance by date

Next:From: John Arbash MeinelDate: 2005-09-22 21:48:22
Subject: Re: Queries 15 times slower on 8.1 beta 2 than on 8.0
Previous:From: Gavin M. RoyDate: 2005-09-22 21:32:21
Subject: Re: Queries 15 times slower on 8.1 beta 2 than on 8.0

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group