Re: [HACKERS] palloc() too large on pg_buffercache with large shared_buffers

2016-09-15 Thread Robert Haas
On Wed, Sep 14, 2016 at 7:59 PM, Kouhei Kaigai wrote: >> On Wed, Sep 14, 2016 at 12:13 AM, Kouhei Kaigai wrote: >> > It looks to me pg_buffercache tries to allocate more than 1GB using >> > palloc(), when shared_buffers is more than 256GB. >> > >> > # show shared_buffers ; >> > shared_buffers >>

Re: [HACKERS] palloc() too large on pg_buffercache with large shared_buffers

2016-09-14 Thread Kouhei Kaigai
> On Wed, Sep 14, 2016 at 12:13 AM, Kouhei Kaigai wrote: > > It looks to me pg_buffercache tries to allocate more than 1GB using > > palloc(), when shared_buffers is more than 256GB. > > > > # show shared_buffers ; > > shared_buffers > > > > 280GB > > (1 row) > > > > # SELECT bu

Re: [HACKERS] palloc() too large on pg_buffercache with large shared_buffers

2016-09-14 Thread Robert Haas
On Wed, Sep 14, 2016 at 12:13 AM, Kouhei Kaigai wrote: > It looks to me pg_buffercache tries to allocate more than 1GB using > palloc(), when shared_buffers is more than 256GB. > > # show shared_buffers ; > shared_buffers > > 280GB > (1 row) > > # SELECT buffers, d.datname, coal