Re: lots of values for IN() clause

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: Markus Schiltknecht <markus(at)bluegap(dot)ch>, pgsql general <pgsql-general(at)postgresql(dot)org>
Subject: Re: lots of values for IN() clause
Date: 2006-11-02 16:44:04
Message-ID: 17585.1162485844@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
> Tom recently added a check for getrlimit(RLIMIT_STACK), but I don't know
> if that considered the "megabyte or so". *peeks the code* Yeah,
> there's a 512 kb "daylight", but there's also an absolute maximum of
> 2MB.

No, there's no absolute maximum (unless I blew the logic). The
*default* if you do not specify max_stack_depth at all is capped at 2MB,
which is the same as the old default. I did that to avoid creating any
new failure if getrlimit lies to us for some reason. Possibly once we
have more confidence in that code, we can be more aggressive about
setting max_stack_depth to getrlimit(RLIMIT_STACK) minus 512K or so.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message brian 2006-11-02 16:56:43 Re: Weird double single quote issue
Previous Message Tom Lane 2006-11-02 16:39:22 Re: lots of values for IN() clause