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

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

From: "Gavin M(dot) Roy" <gmr(at)ehpg(dot)net>
To: "Jean-Pierre Pelletier" <pelletier_32(at)sympatico(dot)ca>
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:32:21
Message-ID: FBF9A147-8D6D-44D6-81F8-53D8D2D51FB0@ehpg.net (view raw or flat)
Thread:
Lists: pgsql-performance
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

Responses

pgsql-performance by date

Next:From: Jean-Pierre PelletierDate: 2005-09-22 21:38:40
Subject: Re: Queries 15 times slower on 8.1 beta 2 than on 8.0
Previous:From: Jean-Pierre PelletierDate: 2005-09-22 21:20:04
Subject: 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