Re: Optimise PostgreSQL for fast testing

From: Dmytrii Nagirniak <dnagir(at)gmail(dot)com>
To: Jan Kesten <jan(at)dafuer(dot)de>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Optimise PostgreSQL for fast testing
Date: 2012-02-23 06:02:38
Message-ID: D62CA552-8CCD-456A-B8FE-DA2010795D39@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2012-02-23 06:05:56 Re: Optimise PostgreSQL for fast testing
Previous Message Jan Kesten 2012-02-23 05:38:04 Re: Optimise PostgreSQL for fast testing