pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Alex Deucher <alexdeucher@gmail.com>
Cc: Jeff Frost <jeff@frostconsultingllc.com>
Cc: Joshua D. Drake <jd@commandprompt.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: strange performance regression between 7.4 and 8.1
Date: Fri, 02 Mar 2007 11:10:11 -0500
Message-ID: <13668.1172851811@sss.pgh.pa.us> (raw)
In-Reply-To: <a728f9f90703020728v197579b6h4e80b8750d0e9a40@mail.gmail.com>
References: <a728f9f90703011244r577d56d7y422ab4bd71bb760e@mail.gmail.com>
	<45E73C90.2080206@commandprompt.com>
	<Pine.LNX.4.64.0703011253040.3892@discord.home.frostconsultingllc.com>
	<a728f9f90703011511m4a0a64fawd65d443ab92b65a4@mail.gmail.com>
	<Pine.LNX.4.64.0703011619120.3892@discord.home.frostconsultingllc.com>
	<a728f9f90703020728v197579b6h4e80b8750d0e9a40@mail.gmail.com>

"Alex Deucher" <alexdeucher@gmail.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



view thread (53+ messages)  latest in thread

Message-ID: <13668.1172851811@sss.pgh.pa.us>
Permalink:  ../13668.1172851811@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/13668.1172851811@sss.pgh.pa.us

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: tgl@sss.pgh.pa.us, alexdeucher@gmail.com, jeff@frostconsultingllc.com, jd@commandprompt.com
  Subject: Re: strange performance regression between 7.4 and 8.1
  In-Reply-To: <13668.1172851811@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox