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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Merlin Moncure | 2004-05-20 19:33:33 | nightly win32 builds |
Previous Message | Jason Priebe | 2004-05-20 17:08:08 | large objects issue |