vacuum info - crash

Поиск
Список
Период
Сортировка
Искать

vacuum info - crash

От:
"Eko Pranoto" <koprapostgres@telkom.net>
Дата:
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

От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
"Eko Pranoto"  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
FAQ