Re: Much Ado About COUNT(*)

On Mon, 24 Jan 2005 08:28:09 -0700, "Jonah H. Harris" <jharris(at)tvi(dot)edu>
wrote:
> UPDATE pg_user_table_counts
> SET rowcount = rowcount + 1
> WHERE schemaname = this_schemaname
> AND tablename = TG_RELNAME;

This might work for small single user applications. You'll have to keep
an eye on dead tuples in pg_user_table_counts though.

But as soon as there are several concurrent transactions doing both
INSERTs and DELETEs, your solution will in the best case serialise
access to test_tbl or it will break down because of deadlocks.

Servus
Manfred