Re: 7.0.2 -> 7.1 performance drop - Mailing list pgsql-general

From Frank Bax
Subject Re: 7.0.2 -> 7.1 performance drop
Date
Msg-id 3.0.6.32.20011114221806.02733d50@pop6.sympatico.ca
Whole thread Raw
In response to Re: 7.0.2 -> 7.1 performance drop  (Jason Earl <jason.earl@simplot.com>)
List pgsql-general
At 05:13 PM 11/12/01 -0700, Jason Earl wrote:
>Doug McNaught <doug@wireboard.com> writes:
>
>> Frank Bax <fbax@sympatico.ca> writes:
>>
>> >            A little more pondering and I remember that I looked a little
>> > closer at startup parms during the PG upgrade.  I had removed -F option.
>> > Put it back in and runtime dropped to 10 minutes again - problem solved!
>>
>> You do understand the implications of -F for your data integrity,
>> right?
>
>Of course, he is rebuilding these tables from scratch every night.  My
>guess is that integrity is not much of an issue.
>
>On the other hand Frank, If you could work your inserts into one large
>transaction you would probably get quite a bit of the benefits of
>removing the -F option without risking the integrity of your database.

On the other hand, I do have other tables to worry about on my system...

I read up on -F during upgrade; that's why I decided to take it out;
default install from OpenBSD packages has this option included in suggested
startup script.

I was just confirming that this option accounted for all the time
difference in processing of my script.

I plan to investigate the impact of using transactions without -F in the
near future.

Thanks for the help guys.  I've been unable to access email for a couple of
days.  Sorry about delay in replying.

Frank

pgsql-general by date:

Previous
From: "Sunit Bhatia"
Date:
Subject: Database server crash ! URGENT !
Next
From: Justin Clift
Date:
Subject: Re: Database server crash ! URGENT !