| From: | David Gould <daveg(at)sonic(dot)net> |
|---|---|
| To: | Nathan Mascitelli <nathanmascitelli(at)geotab(dot)com> |
| Cc: | John R Pierce <pierce(at)hogranch(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #14101: Postgres Service Crashes With Memory Error And Does Not Recover |
| Date: | 2016-04-22 05:13:08 |
| Message-ID: | 20160421221308.258c4fb0@engels |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Wed, 20 Apr 2016 12:37:55 -0400
Nathan Mascitelli <nathanmascitelli(at)geotab(dot)com> wrote:
> That's a good idea, I'll have to play around and see what we can do.
>
> In your opinion would a Linux server be able to handle this setup? Would
> 1000 connections/processes be a problem on Linux?
As long as the machine has the resources, this is not a problem. I have
clients with 1800 to 2000 connections. It will help a bit if you configure
huge pages and you will possibly need to configure more semaphores depending
on what linux version you are on. You can contact me for details if you
actually do this.
-dg
--
David Gould daveg(at)sonic(dot)net
If simplicity worked, the world would be overrun with insects.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mathias Kunter | 2016-04-22 05:49:40 | Re: BUG #14107: Major query planner bug regarding subqueries and indices |
| Previous Message | Tom Lane | 2016-04-22 00:06:59 | Re: BUG #14105: regression for right join - failed to build any 2-way joins |