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

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 (view raw or flat)
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

pgsql-performance by date

Next:From: Josh BerkusDate: 2005-09-22 22:19:05
Subject: Re: Queries 15 times slower on 8.1 beta 2 than on 8.0
Previous:From: Jean-Pierre PelletierDate: 2005-09-22 21:58:49
Subject: Re: 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