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: (view raw or whole 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.


In response to

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


  • 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-2015 The PostgreSQL Global Development Group