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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

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