On Fri, Dec 6, 2013 at 5:02 AM, Etsuro Fujita <[email protected]> wrote: > Though at first I agreed on this, while working on this I start to think > information about (2) is enough for tuning work_mem. Here are examples using > a version under development, where "Bitmap Memory Usage" means (peak) memory > space used by a TIDBitmap, and "Desired" means the memory required to > guarantee non-lossy storage of a TID set, which is shown only when the > TIDBitmap has been lossified. (work_mem = 1MB.)
I'd be wary of showing a desired value unless it's highly likely to be accurate. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
