Re: Optimise PostgreSQL for fast testing

[Jan Kesten <jan@xxxxxxxxx>]

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@xxxxxxxxx>:

Hi guys,

I wonder if you can suggest me how to speed-up PG when running specs.

I asked it at SO here:

http://stackoverflow.com/questions/9407442/optimise-postgresql-for-fast-testing

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