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

help / color / mirror / Atom feed
From: Greg Smith <gsmith@gregsmith.com>
To: pgsql-performance@postgresql.org
Subject: Re: New to PostgreSQL, performance considerations
Date: Tue, 12 Dec 2006 11:08:14 -0500 (EST)
Message-ID: <Pine.GSO.4.64.0612121058230.7466@westnet.com> (raw)
In-Reply-To: <25262.1165906048@sss.pgh.pa.us>
References: <87u002mv49.fsf@wolfe.cbbrowne.com>
	<8a0c7af10612110531sbb019ck259fb16d131fdb50@mail.gmail.com>
	<60psaq5t94.fsf@dba2.int.libertyrms.com>
	<E1GtolA-0008Fk-4R@elasmtp-banded.atl.sa.earthlink.net>
	<20061211173105.GH16692@mathom.us>
	<E1Gtplp-0004Ka-GM@elasmtp-junco.atl.sa.earthlink.net>
	<20061211184726.GI16692@mathom.us>
	<E1GtrB8-0005rw-Iu@elasmtp-kukur.atl.sa.earthlink.net>
	<457DA782.3060506@modgraph-usa.com>
	<8a0c7af10612111422x6bdcc0c2p7cbfeb5a7b0e0374@mail.gmail.com>
	<20061212013706.GM16692@mathom.us>
	<Pine.GSO.4.64.0612120118340.10640@westnet.com>
	<25262.1165906048@sss.pgh.pa.us>

On Tue, 12 Dec 2006, Tom Lane wrote:

> Um, you entirely missed the point: the hardware speedups you mention are
> quite independent of any compiler options.  The numbers we are looking
> at are the relative speeds of two different compiles on the same
> hardware, not whether hardware A is faster than hardware B.

The point that I failed to make clear is that expecting Mike's system to 
perform like Daniel's just because they have similar processors isn't 
realistic, considering the changes that happened in the underlying 
hardware during that period.  Having very different memory subsystems will 
shift which optimizations are useful and which have minimal impact even if 
the processor is basically the same.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD



view thread (124+ messages)  latest in thread

Message-ID: <Pine.GSO.4.64.0612121058230.7466@westnet.com>
Permalink:  ../Pine.GSO.4.64.0612121058230.7466@westnet.com/
Also on:    postgresql.org/message-id/Pine.GSO.4.64.0612121058230.7466@westnet.com

 · 

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: gsmith@gregsmith.com
  Subject: Re: New to PostgreSQL, performance considerations
  In-Reply-To: <Pine.GSO.4.64.0612121058230.7466@westnet.com>

* 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