Re: postgres 9.3 vs. 9.4

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 24/09/14 21:23, Mkrtchyan, Tigran wrote:
Hi Merlin et al.

after building postgres 9.4 myself from sources I get the same performance as
with 9.3. The difference was in the value of debug_assertions setting.

Now the next step. Why my 3 years old laptop gets x1.8 times more tps than my one month old server?
And Mark Kirkwood's desktop gets x2 times more tps as well? Is there some special optimization
for i7 which does not work with Intel(R) Xeon(R) CPU E5-2660?



Yes - firstly, nicely done re finding the assertions (my 9.4 beta2 was built from src - never thought to mention sorry)!

I'd guess that you are seeing some bios setting re the p320 SSD - it *should* be seriously fast...but does not seem to be. You could try running some pure IO benchmarks to confirm this (e.g fio). Also see if the manual for however it is attached to the system allows for some optimized-for-ssd settings that tend to work better (altho these usually imply the drive is plugged into an adapter card of some kind - mind you your p320 *does* used a custom connector that does 2.5" SATA to PCIe style interconnect so I'd look to debug that first).

Cheers

Mark



--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance




[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux