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)
(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).
Remember this performance boost comes at the expense of increased risk of data
loss in the event of a system crash.
In response to
pgsql-general by date
|Next:||From: Ed Loehr||Date: 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: Steve||Date: 1999-12-22 21:00:44|
|Subject: Re: newbie needs help setting up pgsql on linux|