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
>>
> 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
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
Hello,
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, coalesce(c.relname, '???')
FROM (SELECT count(*) buffers, reldatab