fille123
12-22-2009, 09:02 PM
evenin,
when I do Exactly what the manual says to do with the manual analyze i get this message... its longer so tell me if u need it all...
What can i do?
I tried to rebuild the handhistory in some "fix" option... but got some error message there...
Thank you
Nonremovable row versions range from 44 to 48 bytes long.
There were 0 unused item pointers.
Total free space (including removable row versions) is 7336 bytes.
0 pages are or will become empty, including 0 at the end of the table.
1 pages containing 7336 free bytes are potential move destinations.
CPU 0.00s/0.00u sec elapsed 0.00 sec.INFO: index "pokersites_pkey" now contains 16 row versions in 2 pages
DETAIL: 0 index pages have been deleted, 0 are currently reusable.
CPU 0.00s/0.00u sec elapsed 0.00 sec.INFO: "pokersites": moved 0 row versions, truncated 1 to 1 pages
DETAIL: CPU 0.00s/0.00u sec elapsed 0.00 sec.INFO: analyzing "public.pokersites"INFO: "pokersites": scanned 1 of 1 pages, containing 16 live rows and 0 dead rows; 16 rows in sample, 16 estimated total rowsINFO: vacuuming "public.handhistories"
ERROR: invalid page header in block 38084 of relation "handhistories"
ERROR: invalid page header in block 38084 of relation "handhistories"
when I do Exactly what the manual says to do with the manual analyze i get this message... its longer so tell me if u need it all...
What can i do?
I tried to rebuild the handhistory in some "fix" option... but got some error message there...
Thank you
Nonremovable row versions range from 44 to 48 bytes long.
There were 0 unused item pointers.
Total free space (including removable row versions) is 7336 bytes.
0 pages are or will become empty, including 0 at the end of the table.
1 pages containing 7336 free bytes are potential move destinations.
CPU 0.00s/0.00u sec elapsed 0.00 sec.INFO: index "pokersites_pkey" now contains 16 row versions in 2 pages
DETAIL: 0 index pages have been deleted, 0 are currently reusable.
CPU 0.00s/0.00u sec elapsed 0.00 sec.INFO: "pokersites": moved 0 row versions, truncated 1 to 1 pages
DETAIL: CPU 0.00s/0.00u sec elapsed 0.00 sec.INFO: analyzing "public.pokersites"INFO: "pokersites": scanned 1 of 1 pages, containing 16 live rows and 0 dead rows; 16 rows in sample, 16 estimated total rowsINFO: vacuuming "public.handhistories"
ERROR: invalid page header in block 38084 of relation "handhistories"
ERROR: invalid page header in block 38084 of relation "handhistories"