On 07/04/2013 06:05 AM, Andres Freund wrote:
>>> Presumably the smaller segsize is better because we don't
>>> completely stall the system by submitting up to 1GB of io at once. So,
>>> if we were to do it in 32MB chunks and then do a final fsync()
>>> afterwards we might get most of the benefits.
>> Yes, I try to test this setting './configure --with-segsize=0.03125' tonight.
>> I will send you this test result tomorrow.
>
I did testing on this a few years ago, I tried with 2MB segments over
16MB thinking similarly to you. It failed miserably, performance
completely tanked.
JD
--
Command Prompt, Inc. - http://www.commandprompt.com/ 509-416-6579
PostgreSQL Support, Training, Professional Services and Development
High Availability, Oracle Conversion, Postgres-XC, @cmdpromptinc
For my dreams of your image that blossoms a rose in the deeps of my heart. - W.B. Yeats