Skip site navigation (1) Skip section navigation (2)

Re: New to PostgreSQL, performance considerations

From: Cosimo Streppone <cosimo(at)streppone(dot)it>
To: Alexander Staubo <alex(at)purefiction(dot)net>
Cc: Postgresql Performance list <pgsql-performance(at)postgresql(dot)org>
Subject: Re: New to PostgreSQL, performance considerations
Date: 2006-12-16 08:27:01
Message-ID: 4583ADD5.4070703@streppone.it (view raw or flat)
Thread:
Lists: pgsql-performance
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

In response to

pgsql-performance by date

Next:From: jamcitoDate: 2006-12-16 14:29:40
Subject: partition text/varchar check problem
Previous:From: Arjen van der MeijdenDate: 2006-12-16 08:11:59
Subject: Re: opportunity to benchmark a quad core Xeon

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group