[ZODB-Dev] Big catalog indexes/btrees, reads, and the object cache

[Stefan H. Holek]

On 14.12.2012, at 01:26, Jeff Shell wrote:

> The document counts of these indexes are around 170000 items each, and tend to cover every major-ish content object. I'm wondering how this is impacting the object caches and how we should be sizing them.
> 
> Are we hitting a limit on BTree and/or catalog index size?
> Do we need to keep upping the zodb-object-cache size? (What is a good metric for setting that cache size?)

As a rule of thumb, the cache size should be about the same as the catalog size, i.e. at least 170k in your case. I don't know of any other limit in catalog or indexes.

Stefan

-- 
Stefan H. Holek
stefan at epy.co.at