Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

Next:From: Greg StarkDate: 2003-11-30 08:06:03
Subject: Re: -fpic vs. -fPIC
Previous:From: Joe ConwayDate: 2003-11-30 06:45:22
Subject: Re: Patch queue

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group