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