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