Re: Out of memory on SELECT in 8.3.5

Поиск
Список
Период
Сортировка
От Matt Magoffin
Тема Re: Out of memory on SELECT in 8.3.5
Дата
Msg-id 51651.192.168.1.106.1234166190.squirrel@msqr.us
обсуждение исходный текст
Ответ на Re: Out of memory on SELECT in 8.3.5  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Out of memory on SELECT in 8.3.5  ("Matt Magoffin" <postgresql.org@msqr.us>)
Список pgsql-general
> Agreed, that ulimit isn't reflecting any such limit, but is that really
> the same environment the postmaster gets started in?  I wouldn't trust
> a system startup script to be launched in the same environment that a
> login shell gets.  You might try adding
>     ulimit -a >/tmp/something
> to the startup script to find out for sure.

Our startup script is calling

su -l postgres ...

So I thought the limits would be the same (from the -l flag)? I then tried
to mimic this with the following:

[root@170226-db7 ~]# su -l postgres -c "ulimit -a"
core file size          (blocks, -c) 0
data seg size           (kbytes, -d) unlimited
max nice                        (-e) 0
file size               (blocks, -f) unlimited
pending signals                 (-i) 139264
max locked memory       (kbytes, -l) 32
max memory size         (kbytes, -m) unlimited
open files                      (-n) 1024
pipe size            (512 bytes, -p) 8
POSIX message queues     (bytes, -q) 819200
max rt priority                 (-r) 0
stack size              (kbytes, -s) 10240
cpu time               (seconds, -t) unlimited
max user processes              (-u) 139264
virtual memory          (kbytes, -v) unlimited
file locks                      (-x) unlimited

which I think should accurately reflect what the postmaster environment
should be seeing.

Regards,
Matt

В списке pgsql-general по дате отправления:

Предыдущее
От: "Matt Magoffin"
Дата:
Сообщение: Re: Out of memory on SELECT in 8.3.5
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: Out of memory on SELECT in 8.3.5