[EMAIL PROTECTED] wrote: > On Jun 18, 10:44 pm, [EMAIL PROTECTED] (Alvaro Herrera) > wrote: > > > > > Please check "MultiXact" id consumption. Do you mean that your server > > has crashed? > > > How do I check MilitXact id consumption ? Is it "Latest checkpoint's > NextXID:" in the output of pg_controldata ?
No, it is these lines: > Latest checkpoint's NextMultiXactId: 1 > Latest checkpoint's NextMultiOffset: 0 Which are the initial values. This means that you haven't use MultiXacts at all! The message about failing to truncate the dir is certainly a bug, and certainly harmless. > transaction id consumption is ~ 350000 per day (extrapolated from 16 > hours). > No, the Server has been up for about 2 month (regular reboot due to > kernel and postgresql upgrade to 8.1.8), was running before for 7 > month flawless, and before that i migrated from 8.0 to 8.1.4 with a > complete dump/restore). And when was the message logged? -- Alvaro Herrera http://www.advogato.org/person/alvherre "Saca el libro que tu religión considere como el indicado para encontrar la oración que traiga paz a tu alma. Luego rebootea el computador y ve si funciona" (Carlos Duclós) ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
