Re: *sigh*

From: Greg Stark <gsstark(at)mit(dot)edu>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: *sigh*
Date: 2003-11-30 08:00:27
Message-ID: 874qwmffqc.fsf@stark.dyndns.tv
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


Gaetano Mendola <mendola(at)bigfoot(dot)com> writes:

> The count(*) information can be revisioned too, am I wrong ? I'm able to
> create a trigger that store the count(*) information in a special table,
> why not implement the same in a way "builded in" ?

Then every insert or delete would have to lock that count. Nobody else would
be able to insert or delete any records until you either commit or roll back.

That would lead to much lower concurrency, much more contention for locks, and
tons of deadlocks.

--
greg

In response to

  • Re: *sigh* at 2003-11-30 02:21:23 from Gaetano Mendola

Responses

  • Re: *sigh* at 2003-12-03 05:20:35 from Randolf Richardson

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Stark 2003-11-30 08:06:03 Re: -fpic vs. -fPIC
Previous Message Joe Conway 2003-11-30 06:45:22 Re: Patch queue