Re: strange performance regression between 7.4 and 8.1

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Alex Deucher" <alexdeucher(at)gmail(dot)com>
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:10:11
Message-ID: 13668.1172851811@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"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?

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Alex Deucher 2007-03-02 16:14:15 Re: strange performance regression between 7.4 and 8.1
Previous Message Alex Deucher 2007-03-02 16:03:06 Re: strange performance regression between 7.4 and 8.1