Re: [PERFORM] Performance on new 64bit server compared to my 32bit desktop

2010-08-31 Thread Scott Marlowe
On Tue, Aug 31, 2010 at 12:55 PM, Yeb Havinga wrote: > Scott Marlowe wrote: >> >> On Tue, Aug 31, 2010 at 6:41 AM, Yeb Havinga wrote: >> export OMP_NUM_THREADS=4 >>> >>> Then I get the following. The rather wierd dip at 5 threads is consistent >>> over multiple tries: >>> >>> >> >>

Re: [PERFORM] Performance on new 64bit server compared to my 32bit desktop

2010-08-31 Thread Yeb Havinga
Scott Marlowe wrote: On Tue, Aug 31, 2010 at 6:41 AM, Yeb Havinga wrote: export OMP_NUM_THREADS=4 Then I get the following. The rather wierd dip at 5 threads is consistent over multiple tries: I get similar dips on my server. Especially as you make the stream test write a la

Re: [PERFORM] Performance on new 64bit server compared to my 32bit desktop

2010-08-31 Thread Greg Smith
Jose Ildefonso Camargo Tolosa wrote: your i860? http://en.wikipedia.org/wiki/Intel_i860 wow!. :D That's supposed to be i7-860: http://en.wikipedia.org/wiki/List_of_Intel_Core_i7_microprocessors It was a whole $199, so not an expensive processor. Now, seriously: what memory (brand/mode

Re: [PERFORM] Performance on new 64bit server compared to my 32bit desktop

2010-08-31 Thread Scott Marlowe
And, I have zone reclaim set to off because it makes the linux kernel on large cpu machines make pathologically unsound decisions during large file transfers. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.

Re: [PERFORM] Performance on new 64bit server compared to my 32bit desktop

2010-08-31 Thread Scott Marlowe
Note that in that graph, the odd dips are happening every 8 cores on a system with 4 12 core processors. I don't know why, I would expect it to be every 6 or something. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.

Re: [PERFORM] Performance on new 64bit server compared to my 32bit desktop

2010-08-31 Thread Jose Ildefonso Camargo Tolosa
Hi! On Tue, Aug 31, 2010 at 11:13 AM, Greg Smith wrote: > Yeb Havinga wrote: >> >> The rather wierd dip at 5 threads is consistent over multiple tries > > I've seen that twice on 4 core systems now.  The spot where there's just one > more thread than cores seems to be the worst case for cache thr

Re: [PERFORM] Performance on new 64bit server compared to my 32bit desktop

2010-08-31 Thread Yeb Havinga
Jose Ildefonso Camargo Tolosa wrote: Ok, this could explain the huge difference. I was planing on getting GigaByte GA-890GPA-UD3H, with a Phenom II X6 and that ram: Crucial CT2KIT25664BA13​39, Crucial BL2KIT25664FN1608, or something better I find when I get enough money (depending on my budget a

Re: [PERFORM] Performance on new 64bit server compared to my 32bit desktop

2010-08-31 Thread Jose Ildefonso Camargo Tolosa
Hi! On Tue, Aug 31, 2010 at 8:11 AM, Yeb Havinga wrote: > Greg Smith wrote: >> >> Yeb Havinga wrote: >>> >>> model name      : AMD Phenom(tm) II X4 940 Processor @ 3.00GHz >>> cpu cores         : 4 >>> stream compiled with -O3 >>> Function      Rate (MB/s)   Avg time     Min time     Max time >>>

Re: [PERFORM] Performance on new 64bit server compared to my 32bit desktop

2010-08-31 Thread Greg Smith
Yeb Havinga wrote: The rather wierd dip at 5 threads is consistent over multiple tries I've seen that twice on 4 core systems now. The spot where there's just one more thread than cores seems to be the worst case for cache thrashing on a lot of these servers. How much total RAM is in this

Re: [PERFORM] slow DDL creation

2010-08-31 Thread Kevin Kempter
On Monday 30 August 2010 17:04, bricklen wrote: > On Mon, Aug 30, 2010 at 3:28 PM, Kevin Kempter > > wrote: > > Hi all ; > > > > we have an automated partition creation process that includes the > > creation of an FK constraint. we have a few other servers with similar > > scenarios and this is th

Re: [PERFORM] Performance on new 64bit server compared to my 32bit desktop

2010-08-31 Thread Yeb Havinga
Greg Smith wrote: Yeb Havinga wrote: model name : AMD Phenom(tm) II X4 940 Processor @ 3.00GHz cpu cores : 4 stream compiled with -O3 Function Rate (MB/s) Avg time Min time Max time Triad: 5395.1815 0.0089 0.0089 0.0089 I'm not sure if Yeb's st