On 23/02/2012, at 4:38 PM, Jan Kesten wrote:
Hi Dmytrii,
just as short idea, put "fsync = off" in your postgres.conf. That turns off that after a commit data is forcilby written to disk - if the database crashes there might be dataloss.
Thanks. So far I tried:
fsync = off
full_page_writes = off
It seems it got a *little* faster (down to ~65 seconds from ~76) but is till too far from my target of ~34 secs.