3 ms·
> So it seems like 2MB shared buffers shaves a few seconds off our tests. Is 2MB in the range you were thinking of? Well, hard to say without knowing anything
by anarazel 7y ago
> So it seems like 2MB shared buffers shaves a few seconds off our tests. Is 2MB in the range you were thinking of?
Well, hard to say without knowing anything about your tests. I think the cases where I've seen it make a really big difference were more ones where people upped and upped shared_buffers trying to improve test performance, without noticing that it made things worse.
I'd probably not go below 16MB, otherwise it's plausible you could run into some errors (e.g. if you have a large number of cursors or such - they can end up pinning a few buffers, and if there's only 256 buffers, you don't need to be too creative for that).