On Wed, Jan 25, 2006 at 11:42:04AM +0100, H.J. Sanders wrote:
> When I do this I get the message
>
> relation pgstattuple does not exist.
pgstattuple is a function, not a relation, so I suspect the query
isn't referring to it correctly. What's the exact query you ran?
It should look like this:
On Wed, Dec 28, 2005 at 02:15:24PM +0100, H.J. Sanders wrote:
> is there a way to find out how many deleted records there are in
> a table (this gives an indication that it is time to vacuum)?
Use the pgstattuple() function from contrib/pgstattuple.
test=> CREATE TABLE foo (x integer);
CREATE TAB
Hi Folks.
Couldn't find it in any mailing list so:
is there a way to find out how many deleted records there are in a table
(this gives an indication that it is time to vacuum)?
Many thanks
Henk Sanders
---(end of broadcast)--
