Re: strange performance regression between 7.4 and 8.1

From: "Alex Deucher" <alexdeucher(at)gmail(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Jeff Frost" <jeff(at)frostconsultingllc(dot)com>, "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: strange performance regression between 7.4 and 8.1
Date: 2007-03-02 16:14:15
Message-ID: a728f9f90703020814h3b3de4e9ud021ac2e2fc596bf@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 3/2/07, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> "Alex Deucher" <alexdeucher(at)gmail(dot)com> writes:
> > Anyway, new numbers after the analyze.
> > Unfortunately, they are improved, but still not great:
>
> Why are the index names different between the old and new servers?
> Is that just cosmetic, or is 8.2 actually picking a different
> (and less suitable) index for the c1 queries?
>

That's just cosmetic. They are the same.

Alex

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Marlowe 2007-03-02 16:35:01 Re: [kris@obsecurity.org: Progress on scaling of FreeBSD on 8 CPU systems]
Previous Message Tom Lane 2007-03-02 16:10:11 Re: strange performance regression between 7.4 and 8.1