On Fri, 2005-09-30 at 13:31, Joshua D. Drake wrote:
> Shared Row Locking: PostgreSQL's "better than row-level
> locking" has been improved further through the addition of
> shared row locks for foreign keys. Shared locks will improve
> insert and update performance on some OLTP applications
> ^^^^
>
> The word "some" sounds like it is a minority of OLTP applications.
> In general any moderately used OLTP app will benifit from this yes?
>
> many, most, or just say performance on OLTP applications.
>
well, it will really only help on those systems that were stressing out
our current design (and thats really hardware dependent too) so maybe
"busy", "heavy","high load" or just "on OLTP applications".
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL