Re: Win32 VACUUM VERBOSE

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Magnus Hagander <mha(at)sollentuna(dot)net>
Cc: Gavin Sherry <swm(at)linuxworld(dot)com(dot)au>, pgsql-hackers-win32(at)postgresql(dot)org
Subject: Re: Win32 VACUUM VERBOSE
Date: 2004-09-01 22:15:20
Message-ID: 200409012215.i81MFKb02310@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers-win32


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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Browse pgsql-hackers-win32 by date

  From Date Subject
Next Message Tom Lane 2004-09-01 22:29:58 Re: Compiling beta2 with openssl on XP Pro
Previous Message Ronald Kuczek 2004-09-01 19:41:35 Re: Compiling beta2 with openssl on XP Pro