On 06/15/15 05:44, Kaijiang Chen wrote:
I've checked the source codes in postgresql 9.2.4. In function
static bool
grow_memtuples(Tuplesortstate *state)
the codes:
/*
* On a 64-bit machine, allowedMem could be high enough to get us into
* trouble with MaxAllocSize, to
I've checked the source codes in postgresql 9.2.4. In function
static bool
grow_memtuples(Tuplesortstate *state)
the codes:
/*
* On a 64-bit machine, allowedMem could be high enough to get us into
* trouble with MaxAllocSize, too.
*/
if ((Size) (state->me
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 06/13/2015 10:43 AM, Joshua D. Drake wrote:
>
> On 06/13/2015 10:27 AM, Kaijiang Chen wrote:
>> Hi, I am using postgresql 9.2.10 on centos 6.2, 64 bit version.
>> The server has 512 GB mem.
>>
>> The jobs are mainly OLAP like. So I need larger wor
On 06/13/2015 10:27 AM, Kaijiang Chen wrote:
Hi, I am using postgresql 9.2.10 on centos 6.2, 64 bit version. The
server has 512 GB mem.
The jobs are mainly OLAP like. So I need larger work_mem and shared
buffers. From the source code, there is a constant MaxAllocSize==1GB.
So, I wonder whether
Hi, I am using postgresql 9.2.10 on centos 6.2, 64 bit version. The server
has 512 GB mem.
The jobs are mainly OLAP like. So I need larger work_mem and shared
buffers. From the source code, there is a constant MaxAllocSize==1GB. So, I
wonder whether work_mem and shared buffers can exceed 2GB in th