Re: Indexen on 8.0.3 - Mailing list pgsql-general

From Ian Harding
Subject Re: Indexen on 8.0.3
Date
Msg-id 725602300510070940j6b4705b1g8484b2c4611c15bc@mail.gmail.com
Whole thread Raw
In response to Re: Indexen on 8.0.3  (han.holl@informationslogik.nl)
List pgsql-general
On 10/6/05, han.holl@informationslogik.nl <han.holl@informationslogik.nl> wrote:
> On Thursday 06 October 2005 18:20, Tom Lane wrote:
> >
> > No, there's no reason for 8.0 to be slower at this than 7.4, if all else
> > is equal.  I'm betting that all else is not equal.  Maybe you are using
> > a different encoding or locale in the new installation than the old?
> >
> Well, I suspect that something is not equal as well. The trouble is I can't
> seem to find it.
> We're going to replay what happened on a different machine, and hopefully will
> find something.
>

When I went from 7.4 to 8.0 I had queries that were significantly
slower.  I had to tweak work_mem to get them to run at reasonable
speed, and then they were faster than 7.4 with default sort_mem.
Can't remember the details of the queries right now.

> Thanks,
>
> Han Holl
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: PostgreSQL 8.1 vs. MySQL 5.0?
Next
From: David Fetter
Date:
Subject: Re: PostgreSQL 8.1 vs. MySQL 5.0?