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

Re: for help!

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andrew Sullivan <andrew(at)libertyrms(dot)info>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: for help!
Date: 2003-04-16 16:01:56
Message-ID: 18664.1050508916@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
Andrew Sullivan <andrew(at)libertyrms(dot)info> writes:
> But you _could_ write a trigger which inserts into a "staging" table,
> and write a little daemon which only updates the count table with the
> data from the staging table.  It's a mighty ugly hack, but it ought
> to work.

The $64 question with this sort of thing is "how accurate (up-to-date)
does the count have to be?".

Given that Josh is willing to vacuum every five minutes, he might find
that returning pg_class.reltuples is Close Enough (TM).

			regards, tom lane


In response to

Responses

pgsql-performance by date

Next:From: Andrew SullivanDate: 2003-04-16 16:11:58
Subject: Re: for help!
Previous:From: Andrew SullivanDate: 2003-04-16 15:53:12
Subject: Re: for help!

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