Optimise PostgreSQL for fast testing

From: Dmytrii Nagirniak <dnagir(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Optimise PostgreSQL for fast testing
Date: 2012-02-23 05:13:06
Message-ID: CAL_6ryKrJFuNFEHUPC3hGu_4soe-R5odnGHupv1MtW-HKW890w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 <http://www.ApproachE.com>

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jan Kesten 2012-02-23 05:38:04 Re: Optimise PostgreSQL for fast testing
Previous Message Kiriakos Georgiou 2012-02-23 00:51:08 Re: Counting different strings (OK%, FB%) in same table, grouped by week number