Re: Frequent Update Project: Design Overview of HOT Updates

On 11/10/06, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> "Pavan Deolasee" <pavan(dot)deolasee(at)gmail(dot)com> writes:
> > On 11/10/06, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> > (2) Isn't this full of race conditions?
>
> > I agree, there could be race conditions. But IMO we can handle those.
>
> Doubtless you can prevent races by introducing a bunch of additional
> locking. The question was really directed to how much concurrent
> performance is left, once you get done locking it down.
>
>
I understand your point and I can clearly see a chance to improve upon the
current
locking implementation in the prototype even though we are seeing a good
performance
boost for 50 clients and 50 scaling factor with pgbench runs as mentioned by
Nikhil.

Regards,
Pavan