Re: [HACKERS] proposal: adding a GUC for BAS_BULKREAD strategy

2014-09-23 Thread Andres Freund
Hi, On 2014-09-23 14:47:33 +0200, didier wrote: > Currently the value is hard code to NBuffers / 4 but ISTM that with > bigger shared_buffer it's too much, ie even with a DB 10 to 20 time > the memory size there's a lot of tables under this limit and nightly > batch reports are trashing the shared

[HACKERS] proposal: adding a GUC for BAS_BULKREAD strategy

2014-09-23 Thread didier
Hi, Currently the value is hard code to NBuffers / 4 but ISTM that with bigger shared_buffer it's too much, ie even with a DB 10 to 20 time the memory size there's a lot of tables under this limit and nightly batch reports are trashing the shared buffers cache as if there's no tomorrow. regards,