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

Re: Pet Peeves?

From: Greg Smith <gsmith(at)gregsmith(dot)com>
To: Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>
Cc: Gregory Stark <stark(at)enterprisedb(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Pet Peeves?
Date: 2009-01-29 23:37:57
Message-ID: Pine.GSO.4.64.0901291826070.16464@westnet.com (view raw or flat)
Thread:
Lists: pgsql-general
On Thu, 29 Jan 2009, Ron Mayer wrote:

>  - Surely someone wrote a good count(*)-replacement-trigger before.
>    Now where can I find one?  Searching for "count" on pgfoundry
>    doesn't help me.   Searching varlena genralbits find shows me
>    a simple one, but IIRC is lacking when it comes to concurrency.

There were two Varlena postings on this and one other good article.  I got 
sick of not being to find them every time I wanted to and added links to 
them all at http://wiki.postgresql.org/wiki/Slow_Counting

--
* Greg Smith gsmith(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD

In response to

pgsql-general by date

Next:From: Erik JonesDate: 2009-01-30 00:00:53
Subject: Re: Pet Peeves?
Previous:From: Mike DiehlDate: 2009-01-29 22:57:16
Subject: Call volume query

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