Re: [PERFORM] HFS+ pg_test_fsync performance

2014-04-23 Thread Josh Berkus
Mel, I was given anecdotal information regarding HFS+ performance under OSX as being unsuitable for production PG deployments and that pg_test_fsync could be used to measure the relative speed versus other operating systems You're welcome to identify your source of anecdotal evidence: me.

Re: [PERFORM] HFS+ pg_test_fsync performance

2014-04-23 Thread Josh Berkus
On 04/23/2014 11:19 AM, Mel Llaguno wrote: Josh, Thanks for the feedback. Given the prevalence of SSDs/VMs, it would be useful to start collecting stats/tuning for different operating systems for things like fsync (and possibly bonnie++/dd). If the community is interested, I¹ve got a

Re: [PERFORM] HFS+ pg_test_fsync performance

2014-04-15 Thread desmodemone
2014-04-15 0:32 GMT+02:00 Mel Llaguno mllag...@coverity.com: I was given anecdotal information regarding HFS+ performance under OSX as being unsuitable for production PG deployments and that pg_test_fsync could be used to measure the relative speed versus other operating systems (such as

Re: [PERFORM] HFS+ pg_test_fsync performance

2014-04-15 Thread Mel Llaguno
My 2 cents : The results are not surprising, in the linux enviroment the i/o call of pg_test_fsync are using O_DIRECT (PG_O_DIRECT) with also the O_SYNC or O_DSYNC calls, so ,in practice, it is waiting the answer from the storage bypassing the cache in sync mode, while in the Mac OS X it

[PERFORM] HFS+ pg_test_fsync performance

2014-04-14 Thread Mel Llaguno
I was given anecdotal information regarding HFS+ performance under OSX as being unsuitable for production PG deployments and that pg_test_fsync could be used to measure the relative speed versus other operating systems (such as Linux). In my performance lab, I have a number of similarly equipped