Re: Optimise PostgreSQL for fast testing

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: Dmytrii Nagirniak <dnagir(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Optimise PostgreSQL for fast testing
Date: 2012-03-16 08:26:19
Message-ID: CA+U5nMKYGL06af53HOFqoHMuQUPfXdHvwqpPDuXsyRBmvAxBSw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Mar 16, 2012 at 4:38 AM, Dmytrii Nagirniak <dnagir(at)gmail(dot)com> wrote:

> To "fix" it I open a transaction before each test and roll it back at the
> end.
>
> Some numbers for ~700 tests.
>
> - Truncation: SQLite - 34s, PG - 76s.
> - Transaction: SQLite - 17s, PG - 18s.
>
> 2x speed increase for SQLite.
> 4x speed increase for PG.
>
> Hope that'll help some of you.

Did you try this? synchronous_commit = off

--
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2012-03-16 09:45:29 Re: how to measure wal_buffer usage
Previous Message Alban Hertroys 2012-03-16 08:07:33 Re: Problem for restoure data base Postgre