On Fri, Dec 6, 2013 at 5:02 AM, Etsuro Fujita <fujita.ets...@lab.ntt.co.jp> 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 (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
