stack depth

From: Michael H <michael(at)wemoto(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: stack depth
Date: 2015-08-14 15:55:55
Message-ID: 55CE0F8B.2040504@wemoto.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All,

I'm tuning up my database and need to increase the max_stack_depth
parameter in postgresql.conf.

I've edited the /etc/security/limits.conf and added
* soft stack 12288
* hard stack 12288

but I noticed the comments at the top of the file -
#This file sets the resource limits for the users logged in via PAM.
#It does not affect resource limits of the system services.

After saving my changes and rebooting postgresql will not start, I know
that the configuration change I have made will only affect users
authenticated by PAM but I need to amend the stack depth for ALL system
processes.

Can anybody point me in the right direction?

I'm also asking on the CentOS mailing list but have been pointed to the
file above which is not the setting I require.

while logged in I can run ulimit -s 12288 but this only affects the
current shell.

Thanks for your time,

Michael

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Janes 2015-08-14 15:56:59 Re: Extension to rewrite queries before execution
Previous Message Jeff Janes 2015-08-14 15:53:34 Re: Extension to rewrite queries before execution