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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

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