Re: Win32 VACUUM VERBOSE
Bruce Momjian <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.devel.win32 |
|---|---|
| Message-ID | <[email protected]> |
Added to open items list:
o fix negative getrusage() results from VACUUM VERBOSE
---------------------------------------------------------------------------
Magnus Hagander wrote:
> > Hi guys,
> >
> > Not sure if this has been raised but in doing some load testing on the
> > win32 port, I noticed the following:
> >
> > INFO: "branches": removed 45279 row versions in 248 pages
> > DETAIL: CPU 16.-589s/-1.99u sec elapsed 7.54 sec.
> > INFO: "branches": found 45279 removable, 32 nonremovable row
> > versions in
> > 248 pages
> > DETAIL: 17 dead row versions cannot be removed yet.
> > There were 0 unused item pointers.
> > 0 pages are entirely empty.
> > CPU 1081881273.-1123s/-1.-1143u sec elapsed 17.18 sec.
> >
> >
> > Note the CPU lines.
>
> Yup. Known issue. I'm on this one. Shouldn't be hard, I think :-)
>
>
> //Magnus
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>
--
Bruce Momjian | http://candle.pha.pa.us
[email protected] | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend