| From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
|---|---|
| To: | Gregory Stark <stark(at)enterprisedb(dot)com> |
| Cc: | Heikki Linnakangas <heikki(at)enterprisedb(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Jignesh K(dot) Shah" <J(dot)K(dot)Shah(at)Sun(dot)COM>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: LDC - Load Distributed Checkpoints with PG8.3b2 on Solaris |
| Date: | 2007-11-19 13:58:38 |
| Message-ID: | 20071119135838.GC13505@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Gregory Stark wrote:
> "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com> 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?
The first 65 pages could be empty.
--
Alvaro Herrera http://www.PlanetPostgreSQL.org/
Bob [Floyd] used to say that he was planning to get a Ph.D. by the "green
stamp method," namely by saving envelopes addressed to him as 'Dr. Floyd'.
After collecting 500 such letters, he mused, a university somewhere in
Arizona would probably grant him a degree. (Don Knuth)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-11-19 15:20:24 | Re: possible to create multivalued index from xpath() results in 8.3? |
| Previous Message | Andrew Dunstan | 2007-11-19 13:31:43 | Re: [HACKERS] fulltext parser strange behave |