> Tatsuo Ishii <[EMAIL PROTECTED]> writes: > > I have written a small function that show how many tuples are dead > > etc. in a specified table. > > Dead according to whose viewpoint? Under MVCC this seems to be > in the eye of the beholder...
You can know if the tuple is visible to other backends, or at least take a good guess like VACUUM does. Maybe he has coded that in there. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])