Обсуждение: Win32 VACUUM VERBOSE
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. This is on Win XP Professional. Gavin
Gavin Sherry <swm@linuxworld.com.au> writes:
> Note the CPU lines.
It was already pointed out that getrusage seems to be broken on
Windows. Any ideas about fixing it?
regards, tom lane
> 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
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
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073