Re: Number of open files

"Mark Alliban" <MarkA(at)idnltd(dot)com> writes:
> 530MB of swap. top reports that the backends use around 17-19MB on average.
> Are you saying then, that if I have 500 concurrent queries, I will need 8GB
> of swap space?

Something like that. You weren't expecting to support 500 concurrent
queries on toy iron, I hope.

> Is there any way to limit the amount of memory a backend can
> use, and if there is, would it be a very bad idea to do it?

Can't think of anything very productive offhand. We have gotten rid of
some memory-leak problems in 7.1, so you may find that the next release
will not need so much memory. Or perhaps you can rewrite your queries
to not need so much --- can you determine which queries bloat the
backend to that size?

regards, tom lane