Re: [GENERAL] Slowdown problem when writing 1.7million records

2001-05-10 Thread Tom Lane
This is a followup to a problem report Stephen Livesey made back in February, to the effect that successive insertions got slower and slower. At the time we speculated that btree indexes had a problem with becoming out-of-balance when fed steadily increasing data values. I have now tried to repro

RE: [GENERAL] Slowdown problem when writing 1.7million records

2001-03-02 Thread Creager, Robert S
] > Sent: Wednesday, February 28, 2001 2:20 AM > To: Tom Lane > Cc: [EMAIL PROTECTED] > Subject: RE: [GENERAL] Slowdown problem when writing > 1.7million records > > > > > > No, it's not. Do you have any triggers or rules on this table that > > you hav

RE: [GENERAL] Slowdown problem when writing 1.7million records

2001-03-02 Thread Stephen Livesey
> No, it's not. Do you have any triggers or rules on this table that > you haven't shown us? How about other tables referencing this one > as foreign keys? (Probably not, if you're running an identical test > on MySQL, but I just want to be sure that I'm not missing something.) I have no tri