From: Jean-Pierre Pelletier <pelletier_32@sympatico.ca>
To: Gavin M. Roy <gmr@ehpg.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: Queries 15 times slower on 8.1 beta 2 than on 8.0
Date: Thu, 22 Sep 2005 17:38:40 -0400
Message-ID: <BAYC1-PASMTP0421C246AB993A0ED6542B95970@CEZ.ICE> (raw)
References: <BAYC1-PASMTP01EE67AD3A0034394D85D895970@CEZ.ICE>
<FBF9A147-8D6D-44D6-81F8-53D8D2D51FB0@ehpg.net>
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@postgresql.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@ehpg.net
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: pelletier_32@sympatico.ca, gmr@ehpg.net
Subject: Re: Queries 15 times slower on 8.1 beta 2 than on 8.0
In-Reply-To: <BAYC1-PASMTP0421C246AB993A0ED6542B95970@CEZ.ICE>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox