Re: Update Performance from 6.5.0 to 6.5.3 to 7.0

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Bryan White" <bryan(at)arcamax(dot)com>
Cc: "Alfred Perlstein" <bright(at)wintelcom(dot)net>, "pgsql-general" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Update Performance from 6.5.0 to 6.5.3 to 7.0
Date: 2000-05-26 21:54:44
Message-ID: 3738.959378084@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"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?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2000-05-26 22:00:56 Re: INSERT/UPDATE in views fail silently
Previous Message Tom Lane 2000-05-26 21:45:27 Re: Speed of locating tables?