Re: Update Performance from 6.5.0 to 6.5.3 to 7.0

* Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> [000526 15:43] wrote:
> "Bryan White" <bryan(at)arcamax(dot)com> writes:
> >>>> 4, I could probably get by with just 2 If I had to. I will give it a
> >>>> try.
>
> > With the indexes deleted I am now getting 40 or 50 updates per second
> > instead of 5.
>
> That's good, but does it mean that 7.0 is slower about adding index
> entries than 6.5 was? Or did you have fewer indexes on the table
> when you were using 6.5?

I'm quite sure we experianced the same problem (mutliple indexes causing
slow update/inserts) when we moved an identical table structure from
6.5 to 7.0

-Alfred