Re: Choosing parallel_degree

From: tushar <tushar(dot)ahuja(at)enterprisedb(dot)com>
To: Robert Haas <robertmhaas(at)gmail(dot)com>, Julien Rouhaud <julien(dot)rouhaud(at)dalibo(dot)com>
Cc: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, James Sewell <james(dot)sewell(at)lisasoft(dot)com>, David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Paul Ramsey <pramsey(at)cleverelephant(dot)ca>, Andreas Ulbrich <andreas(dot)ulbrich(at)matheversum(dot)de>
Subject: Re: Choosing parallel_degree
Date: 2016-04-12 08:06:54
Message-ID: 570CAC9E.5090509@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 04/11/2016 09:14 PM, Robert Haas wrote:
>>> postgres=# explain analyze verbose select * from abd where n<=1;
>>> >>ERROR: requested shared memory size overflows size_t
>>> >>
>>> >>if we remove the analyze keyword then query running successfully.
>>> >>
>>> >>Expected = Is it not better to throw the error at the time of setting
>>> >>max_parallel_degree, if not supported ?
>> >
>> >+1
> It surprises me that that request overflowed size_t. I guess we
> should look into why that's happening. Did you test this on a 32-bit
> system?
No, I tested on 64 bit machine.

--
regards,tushar

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2016-04-12 08:18:21 Re: [COMMITTERS] pgsql: Code cleanup in the wake of recent LWLock refactoring.
Previous Message Alexander Korotkov 2016-04-12 07:19:46 Re: Move PinBuffer and UnpinBuffer to atomics