Skip site navigation (1) Skip section navigation (2)

Win32 port CPU times

From: "Gary Doades" <gpd(at)gpdnet(dot)co(dot)uk>
To: pgsql-hackers-win32(at)postgresql(dot)org
Subject: Win32 port CPU times
Date: 2004-05-20 19:30:59
Message-ID: 40AD1583.5908.F999755@localhost (view raw or flat)
Thread:
Lists: pgsql-hackers-win32
Not sure if this is known about, I can't find any mention on the lists:

Latest Win32 binary from http://www.hagander.net/pgsql/win32snap/

CPU times reported in vacuum seem to be a bit off! Partial output attached.

Platform: Windows XP
CPU: AMD athlon XP2800+

Regards,
Gary.

INFO:  vacuuming "information_schema.sql_sizing"
INFO:  "sql_sizing": found 0 removable, 23 nonremovable row versions in 1 pages
DETAIL:  0 dead row versions cannot be removed yet.
There were 9 unused item pointers.
0 pages are entirely empty.
CPU -27568433.-1383s/-1.99u sec elapsed 0.00 sec.
INFO:  vacuuming "pg_toast.pg_toast_17155"
INFO:  index "pg_toast_17155_index" now contains 0 row versions in 1 pages
DETAIL:  0 index pages have been deleted, 0 are currently reusable.
CPU -15224704.1800s/0.00u sec elapsed 0.00 sec.
INFO:  "pg_toast_17155": found 0 removable, 0 nonremovable row versions in 0 pages
DETAIL:  0 dead row versions cannot be removed yet.
There were 0 unused item pointers.
0 pages are entirely empty.
CPU 1055221261.-1353s/0.00u sec elapsed 0.00 sec.
INFO:  vacuuming "information_schema.sql_sizing_profiles"
INFO:  "sql_sizing_profiles": found 0 removable, 0 nonremovable row versions in 0 
pages
DETAIL:  0 dead row versions cannot be removed yet.
There were 0 unused item pointers.
0 pages are entirely empty.
CPU -15231065.-1383s/0.617u sec elapsed 0.00 sec.
INFO:  vacuuming "pg_toast.pg_toast_17160"
INFO:  index "pg_toast_17160_index" now contains 0 row versions in 1 pages
DETAIL:  0 index pages have been deleted, 0 are currently reusable.
CPU -15224704.1609s/0.00u sec elapsed 0.00 sec.
INFO:  "pg_toast_17160": found 0 removable, 0 nonremovable row versions in 0 pages
DETAIL:  0 dead row versions cannot be removed yet.
There were 0 unused item pointers.
0 pages are entirely empty.
CPU 1055251957.-1353s/0.00u sec elapsed 0.00 sec.
INFO:  vacuuming "information_schema.sql_features"
INFO:  "sql_features": found 0 removable, 360 nonremovable row versions in 5 pages
DETAIL:  0 dead row versions cannot be removed yet.
There were 0 unused item pointers.
0 pages are entirely empty.
CPU -27528081.-1383s/-1.99u sec elapsed 0.00 sec.
INFO:  vacuuming "pg_toast.pg_toast_17135"
INFO:  index "pg_toast_17135_index" now contains 0 row versions in 1 pages
DETAIL:  0 index pages have been deleted, 0 are currently reusable.
CPU -15224704.1609s/0.00u sec elapsed 0.00 sec.
INFO:  "pg_toast_17135": found 0 removable, 0 nonremovable row versions in 0 pages
DETAIL:  0 dead row versions cannot be removed yet.
INFO:  free space map: 348 relations, 395 pages stored; 5744 total pages needed
DETAIL:  Allocated FSM size: 1000 relations + 20000 pages = 178 kB shared memory.

Total query runtime: 761 ms.

pgsql-hackers-win32 by date

Next:From: Merlin MoncureDate: 2004-05-20 19:33:33
Subject: nightly win32 builds
Previous:From: Jason PriebeDate: 2004-05-20 17:08:08
Subject: large objects issue

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group