Win32 port CPU times
| От | Gary Doades |
|---|---|
| Тема | Win32 port CPU times |
| Дата | |
| Msg-id | 40AD1583.5908.F999755@localhost обсуждение исходный текст |
| Список | 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 по дате отправления: