> -----Original Message----- > From: Robert Treat [mailto:[EMAIL PROTECTED] > Sent: 11 October 2004 22:30 > To: Dave Page > Cc: [EMAIL PROTECTED] > Subject: Re: [HACKERS] PL/PgSQL for counting all rows in all tables. > > How do you handle table growth that makes the reltuples value > out of whack since the last analyze? Seems unfortunate that > people may not realize that the numbers they are looking at > are incorrect but I don't see much way to avoid it.
Right-click the table object and select 'Count' on the current versions. Previously, iirc it showed the message 'Refresh table to count' in the actual count field, so you did a right-click -> Refresh. > Seems new tables would have that problem too since they would > default to 1000... do you analyze after table creation? No. 1000 is below the default threshold, so it'll get counted. If you lower the threshold, it will say 'not counted' in the actual count field. Regards, Dave. ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
