From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "Mark Alliban" <MarkA(at)idnltd(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Number of open files |
Date: | 2001-02-07 16:27:33 |
Message-ID: | 28613.981563253@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
"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
From | Date | Subject | |
---|---|---|---|
Next Message | Brice Ruth | 2001-02-07 16:38:53 | Re: [SQL] Re: SQL Join - MySQL/PostgreSQL difference? |
Previous Message | Mark Alliban | 2001-02-07 16:20:10 | Re: Number of open files |