Re: count(*) performance - Mailing list pgsql-performance

From Tom Lane
Subject Re: count(*) performance
Date
Msg-id 24743.1143501228@sss.pgh.pa.us
Whole thread Raw
In response to Re: count(*) performance  ("Matthew T. O'Connor" <matthew@zeut.net>)
List pgsql-performance
"Matthew T. O'Connor" <matthew@zeut.net> writes:
> It is fairly easy to implement, however it has been discussed before and
> decided that it wasn't necessary.  What the system cares about is how
> long it's been since the last vacuum in terms of XIDs not time.

I think Alvaro is intending to do the latter (store per-table vacuum xid
info) for 8.2.

            regards, tom lane

pgsql-performance by date:

Previous
From: "Matthew T. O'Connor"
Date:
Subject: Re: count(*) performance
Next
From: "Mikael Carneholm"
Date:
Subject: Re: count(*) performance