| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | Josh Berkus <josh(at)agliodbs(dot)com>, Bruce Momjian <bruce(at)momjian(dot)us> |
| Cc: | Mason S <masonlists(at)gmail(dot)com>, obartunov(at)gmail(dot)com, Simon Riggs <simon(at)2ndquadrant(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Horizontal scalability/sharding |
| Date: | 2015-09-01 17:17:38 |
| Message-ID: | 55E5DDB2.2020205@commandprompt.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 09/01/2015 10:06 AM, Josh Berkus wrote:
> On 09/01/2015 02:39 AM, Bruce Momjian wrote:
>> On Mon, Aug 31, 2015 at 01:16:21PM -0700, Josh Berkus wrote:
> Our real future bottlenecks are:
>
> * ability to handle more than a few hundred connections
This, 1000 times this. No a connection pooler doesn't help, we are using
1000 connections WITH a connection pooler. The amount of data centric,
always connected (even if stateless) apps that are out there is
astounding. Our performance curve is better (especially since Robert's
fantastic work on 9.2) but it isn't where a lot of the demanding users
need to be.
We are also seeing a vast uptick in always connected apps that aren't
web centric (or the client at least isn't). In other words we are seeing
situations where 1000 connections is 1000 users, connected.
JD
--
Command Prompt, Inc. - http://www.commandprompt.com/ 503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Announcing "I'm offended" is basically telling the world you can't
control your own emotions, so everyone else should do it for you.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2015-09-01 17:46:17 | Re: Horizontal scalability/sharding |
| Previous Message | Robert Haas | 2015-09-01 17:17:36 | Re: Horizontal scalability/sharding |