Hi, On 22 Listopad 2013, 20:09, Edson Richter wrote: > > Excuse me (or just ignore me) if it is a stupid question, but have you > configured sysctl.conf accordingly? > For instance, to use larget memory settings, I had to configure my EL as > follows: > > # Controls the maximum shared segment size, in bytes > kernel.shmmax = 68719476736 > > # Controls the maximum number of shared memory segments, in pages > kernel.shmall = 4294967296 This only influences shared memory, which is used for shared buffers (not for memory allocated during query execution, as that's translated to plain malloc). With sysctl.conf misconfigured, the database would not start at all and you'd get a reasonable error message in the log, suggesting pretty clearly where/how to fix it. Tomas -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
