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 p
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 performance lab that I¹d be willing to help run
tests on
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.
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 i
2014-04-15 0:32 GMT+02:00 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 performa
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 Li
