=?UTF-8?B?6auY5YGl?= <luckyjack...@gmail.com> writes:
> If data grows rapidly, maybe our customer will use too much memory , Is
> ulimit command a good idea for PG?
There's no received wisdom saying that it is. There's a fairly widespread
consensus that disabling OOM kill can be a good idea, but I don't recall
that many people have tried setting specific ulimits on server processes.
Keep in mind that exceeding a ulimit would cause queries to fail outright
(whether the server was under much load or not), versus just getting
slower if the server starts to swap under too much load. I can imagine
situations where that would be considered a good tradeoff, but it's hardly
right for everyone.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
