Skip site navigation (1) Skip section navigation (2)

[GENERAL] fsync performance impact

From: Ed Loehr <ELOEHR(at)austin(dot)rr(dot)com>
To: pg-gen <pgsql-general(at)postgresql(dot)org>
Subject: [GENERAL] fsync performance impact
Date: 1999-12-22 21:53:09
Message-ID: 38614845.A012B24@austin.rr.com (view raw or flat)
Thread:
Lists: pgsql-general
Thought some would like to see a little quatitative data on the impact of running
with the -F flag...

Test case:  Using psql via stdin to load 5,238 inserts of the following form:

    INSERT INTO exchange_rate
    ( from_currency_id, to_currency_id, rate, start_time)
    VALUES
    (150,164, 6.01500000, '09/04/1999');

Platform:  RH6.1, 2.2.12-20smp, dual P3 600Mhz, 1 Gb RAM, 3 10K rpm scsi drives
in software raid.

Without -F, it loaded in 228 seconds (~23 inserts/sec).
With -F, it loaded in 10 seconds (~524 inserts/sec).

2200% boost...

Remember this performance boost comes at the expense of increased risk of data
loss in the event of a system crash.

Cheers,
Ed Loehr


In response to

pgsql-general by date

Next:From: Ed LoehrDate: 1999-12-23 01:56:54
Subject: Re: [GENERAL] Index pg_proc_prosrc_index: NUMBER OF INDEX' TUPLES (1071)ISNOT THE SAME AS HEAP' (1070)
Previous:From: SteveDate: 1999-12-22 21:00:44
Subject: Re: newbie needs help setting up pgsql on linux

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group