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

From: John Arbash Meinel <john(at)arbash-meinel(dot)com>
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 22:03:16
Message-ID: 43332A24.8000809@arbash-meinel.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Jean-Pierre Pelletier wrote:
> Here are the explain analyze:

What is the explain analyze if you use "set enable_seqscan to off"?

Also, can you post the output of:
\d supplier
\d price
\d content

Mostly I just want to see what the indexes are, in the case that you
don't want to show us your schema.

John
=:->

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Josh Berkus 2005-09-22 22:19:05 Re: Queries 15 times slower on 8.1 beta 2 than on 8.0
Previous Message Jean-Pierre Pelletier 2005-09-22 21:58:49 Re: Queries 15 times slower on 8.1 beta 2 than on 8.0