Thread: vacuum info - crash

vacuum info - crash

From
"Eko Pranoto"
Date:
Hello, I'm a newbie

I have recieve information from vacuum verbose analyze
I don't know meaning of "Crash 5402"

Anyone can explain aboyut that ?

Regards
EKo PRanoto

---------VACUUM Message----------------------
NOTICE:  --Relation nolab_null--
NOTICE:  Pages 5357: Changed 0, reaped 5357, Empty 0, New
0; Tup 0: Vac 1092766, Keep/VTL 0/0,
Crash 5402, UnUsed 0, MinLen 0, MaxLen 0; Re-using:
Free/Avail. Space 39406340/0;
EndEmpty/Avail. Pages 5357/0. CPU 0.31s/0.12u sec.
NOTICE:  Index nolab_null_mintalab_dt_id_heade: Pages
5867; Tuples 0: Deleted 1092765.
CPU 1.50s/8.62u sec.
NOTICE:  Rel nolab_null: Pages: 5357 --> 0.
NOTICE:  Analyzing...
---------------------------------------------
===========================================================================================
"TELKOMNet Instan memberikan diskon 40% untuk akses malam hari dari pukul 23.00 sampai 06.00.
Berlaku untuk wilayah Jawa Timur mulai 1 Mei 2003 sampai 30 Juni 2003."
===========================================================================================

Re: vacuum info - crash

From
Tom Lane
Date:
"Eko Pranoto" <koprapostgres@telkom.net> writes:
> I have recieve information from vacuum verbose analyze
> I don't know meaning of "Crash 5402"

A little digging in the source code finds that that count last appeared
in 7.1, and it said

        /*
         * Not Aborted, Not Committed, Not in Progress -
         * so it's from crashed process. - vadim 11/26/96
         */
        ncrash++;

ie., you had 5402 rows that were inserted by a transaction that crashed
before committing.

My take on it would be that you should consider updating to a newer
Postgres release.  Whatever the problem was, it's likely to have been
fixed.

            regards, tom lane