Postgres Pro
Downloads
Home   >   mailing lists

proposal: adding a GUC for BAS_BULKREAD strategy - Mailing list pgsql-hackers

From didier
Subject proposal: adding a GUC for BAS_BULKREAD strategy
Date
Msg-id CAJRYxuL98fE_QN7McnCM5HUo8p9ceNJw=20GoN5NVdZdueJFqg@mail.gmail.com
Whole thread Raw
Responses Re: proposal: adding a GUC for BAS_BULKREAD strategy
List pgsql-hackers
Tree view 
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,

pgsql-hackers by date:

Previous
From: Rajeev rastogi
Date:
Subject: Re: Index scan optimization
Next
From: Andres Freund
Date:
Subject: Re: proposal: adding a GUC for BAS_BULKREAD strategy