"Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes: > The sessions table holds normal site session data, like a uid, username, > some other stuff, etc. However entries older than two hours or so get > deleted. We VACUUM everynight, so why is the on-disk relation growing so > huge?
FSM not big enough, perhaps? Try doing a vacuum full, then looking to see how big the table is (in physical blocks) after one day's normal usage. You need at least enough FSM space for that many blocks ... unless you want to vacuum it more often. > However, I cannot repeat the error now. If you can't reproduce the error then I'm pretty well convinced that there is no problem in the stored data itself. This was either a hardware glitch or a software bug causing a memory stomp on the top byte of an item pointer retrieved from the index. Although I can't rule out the latter, I find it unlikely given that we don't have similar reports from other people. You may as well do the VACUUM FULL --- I doubt we can learn anything from examining the table. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly