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

help / color / mirror / Atom feed
From: Cosimo Streppone <cosimo@streppone.it>
To: Alexander Staubo <alex@purefiction.net>
Cc: Postgresql Performance list <pgsql-performance@postgresql.org>
Subject: Re: New to PostgreSQL, performance considerations
Date: Sat, 16 Dec 2006 09:27:01 +0100
Message-ID: <4583ADD5.4070703@streppone.it> (raw)
In-Reply-To: <44088FE9-4AA9-4FD6-AE8F-34560A6401BA@purefiction.net>
References: <C1A31C39.15548%llonergan@greenplum.com>
	<Pine.GSO.4.64.0612140950460.11833@westnet.com>
	<4CD99FDA-14B5-4EA9-9440-55E2548C34C1@purefiction.net>
	<E1GuwGL-0004LX-2x@elasmtp-spurfowl.atl.sa.earthlink.net>
	<BCA64E3D-E764-432B-82CB-C2FC75CF3104@purefiction.net>
	<E1Gv0ko-0004Ht-Jx@elasmtp-scoter.atl.sa.earthlink.net>
	<CA660CCB-712C-442F-A48D-4152EF0EFF01@purefiction.net>
	<E1Gv3Rc-0007M7-5X@elasmtp-galgo.atl.sa.earthlink.net>
	<09D6591B-4AA9-4994-BED6-0C7C583BF933@purefiction.net>
	<E1GvBfR-0005f3-11@elasmtp-scoter.atl.sa.earthlink.net>
	<b42b73150612150623s761783c8l9093b2637a1f0c6c@mail.gmail.com>
	<Pine.GSO.4.64.0612150945440.7368@westnet.com>
	<E1GvGJR-0006HJ-OQ@elasmtp-mealy.atl.sa.earthlink.net>
	<44088FE9-4AA9-4FD6-AE8F-34560A6401BA@purefiction.net>

Alexander Staubo wrote:

> On Dec 15, 2006, at 17:53 , Ron wrote:
> 
>> At 09:50 AM 12/15/2006, Greg Smith wrote:
>>
>>> On Fri, 15 Dec 2006, Merlin Moncure wrote:
>>>
>>>> The slower is probably due to the unroll loops switch which can  
>>>> actually hurt code due to the larger footprint (less cache  coherency).
>>>
>>> The cache issues are so important with current processors that I'd  
>>> suggest throwing -Os (optimize for size) into the mix people  test.  
> 
> So far I have been compiling PostgreSQL and running my pgbench script  
> manually, but this makes me want to modify my script to run pgbench  
> automatically using all possible permutations of a set of compiler  flags.

I don't know if it's practical, but this link comes to mind:

http://clusty.com/search?query=acovea

-- 
Cosimo



view thread (124+ messages)  latest in thread

Message-ID: <4583ADD5.4070703@streppone.it>
Permalink:  ../4583ADD5.4070703@streppone.it/
Also on:    postgresql.org/message-id/4583ADD5.4070703@streppone.it

 · 

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: cosimo@streppone.it, alex@purefiction.net
  Subject: Re: New to PostgreSQL, performance considerations
  In-Reply-To: <4583ADD5.4070703@streppone.it>

* 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