Re: Queries 15 times slower on 8.1 beta 2 than on 8.0 - Mailing list pgsql-performance

From John Arbash Meinel
Subject Re: Queries 15 times slower on 8.1 beta 2 than on 8.0
Date
Msg-id 43332A24.8000809@arbash-meinel.com
Whole thread Raw
In response to Re: Queries 15 times slower on 8.1 beta 2 than on 8.0  ("Jean-Pierre Pelletier" <pelletier_32@sympatico.ca>)
List 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
=:->

Attachment

pgsql-performance by date:

Previous
From: "Jean-Pierre Pelletier"
Date:
Subject: Re: Queries 15 times slower on 8.1 beta 2 than on 8.0
Next
From: Josh Berkus
Date:
Subject: Re: Queries 15 times slower on 8.1 beta 2 than on 8.0