"Heikki Linnakangas" <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> Looking at the autovacuum log output, >> >>> 2007-11-13 09:21:19.830 PST 9458 LOG: automatic vacuum of table >>> "specdb.public.txn_log_table": index scans: 1 >>> pages: 11 removed, 105 remain >>> tuples: 3147 removed, 40 remain >>> system usage: CPU 0.11s/0.09u sec elapsed 6.02 sec >> >> it seems like a serious omission that this gives you no hint how many >> pages were scanned. > > Isn't it pages removed + remain? 116 in this case.
How do 40 tuples take 105 pages? -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's Slony Replication support! ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
