RE: Tuning threshold for BAS_BULKREAD (large tables)

2019-01-22 Thread Jamison, Kirk
Re: Tuning threshold for BAS_BULKREAD (large tables) On 1/22/19 1:35 AM, Jamison, Kirk wrote: Hi, I have a source code-related question on BufferAccessStrategyType BAS_BULKREAD. Currently, this access method is set internally to cache tables larger than 1/4 of shared_buffers. src/backend/access/h

Re: Tuning threshold for BAS_BULKREAD (large tables)

2019-01-22 Thread Ron
On 1/22/19 1:35 AM, Jamison, Kirk wrote: Hi, I have a source code-related question on BufferAccessStrategyType BAS_BULKREAD. Currently, this access method is set internally to cache tables larger than 1/4 of shared_buffers. src/backend/access/heap/heapam.c:initscan() if (!RelationUs

Tuning threshold for BAS_BULKREAD (large tables)

2019-01-21 Thread Jamison, Kirk
Hi, I have a source code-related question on BufferAccessStrategyType BAS_BULKREAD. Currently, this access method is set internally to cache tables larger than 1/4 of shared_buffers. src/backend/access/heap/heapam.c:initscan() if (!RelationUsesLocalBuffers(scan->rs_rd) && scan->rs_n