Re: Thoughts on Logical Log use requested

Colin Dawson said: > It > also > says that only the used pages are written to disk, so no matter how big > the > log buffer is, the only wastage is a partial page and no where near the > 75% > estimate by TBP which is the point I was trying to make. Where does it say this? >>From: "Obnoxio The Clown" <obnoxio@serendipita.com> >> >>Colin Dawson said: >> > i did that well before i asked the question. >> > >> > FYI (from the FM) >> > It is recommended that you set LOGBUFF to 16 or 32 kilobytes, or >> perhaps >> > 64 kilobytes for heavy workloads. >> >>The buffer gets flushed. >> >>The WHOLE buffer gets flushed. >> >>If the buffer is empty (as in your case), it flushes 32 pages, even >> though >>only one of them is full. >> >>It *is* in the manual. Somewhere. >> >> >>From: "Obnoxio The Clown" <obnoxio@serendipita.com> >> >> >> >>Colin Dawson said: >> >> > Surely whenever data is written to the log >> >> > it >> >> > does not write the unused portion of log buffer? >> >> >> >>RTFM. -- Bye now, Obnoxio "It's easier with pictures." -- Cosmo "But wait, it gets worse." -- Cosmo "Run, don't walk, for the nearest exit." -- Cosmo