On Fri, Mar 16, 2012 at 4:38 AM, Dmytrii Nagirniak <dnagir@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
