Postgres Pro
Downloads
Home   >   mailing lists

Re: Optimise PostgreSQL for fast testing - Mailing list pgsql-general

From Jan Kesten
Subject Re: Optimise PostgreSQL for fast testing
Date
Msg-id C890871B-7744-409B-B1D3-4E56EA53CD63@dafuer.de
Whole thread Raw
In response to Optimise PostgreSQL for fast testing  (Dmytrii Nagirniak <dnagir@gmail.com>)
Responses Re: Optimise PostgreSQL for fast testing  (Dmytrii Nagirniak <dnagir@gmail.com>)
List pgsql-general
Tree view
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.

Von meinem iPhone gesendet

Am 23.02.2012 um 06:13 schrieb Dmytrii Nagirniak <dnagir@gmail.com>:

Hi guys,

I wonder if you can suggest me how to speed-up PG when running specs.
I asked it at SO here:


But briefly. PG specs are >2x slower than SQLite.
I want it to be on par (don't care about reliability or anything, just need fast specs).

Would appreciate some suggestions.

Cheers,
Dmytrii Nagirniak
http://ApproachE.com

pgsql-general by date:

Previous
From: Dmytrii Nagirniak
Date:
Subject: Optimise PostgreSQL for fast testing
Next
From: Dmytrii Nagirniak
Date:
Subject: Re: Optimise PostgreSQL for fast testing