| Lists: | pgsql-in-general |
|---|
| From: | S Ahmed <sahmed1020(at)gmail(dot)com> |
|---|---|
| To: | pgsql-in-general(at)postgresql(dot)org |
| Subject: | Re: postgres java driver, can I connect to a server instead of a database? |
| Date: | 2014-08-20 20:04:40 |
| Message-ID: | CAG2rwuNh2+Pp1dggZ=gCcB4vZV3_YRz7DXLMQpcs9HDhkF+QMg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-in-general |
Hello,
In a Saas application that has 1 database per customer, you may have
thousands of customers and therefore thousands of databases.
Creating thousands of connection pools is very costly memory wise.
What options are there with the postgres java driver currently?
Say I have 1 server with 500 customer databases on it.
Can I somehow create 1 connection pool to the server, and then switch to
the correct database on a per query basis? Or does the driver not support
this?
Or maybe this isn't a driver specific issue but rather a connection pool
question?
| From: | Jayadevan M <maymala(dot)jayadevan(at)gmail(dot)com> |
|---|---|
| To: | S Ahmed <sahmed1020(at)gmail(dot)com> |
| Cc: | pgsql-in-general(at)postgresql(dot)org |
| Subject: | Re: postgres java driver, can I connect to a server instead of a database? |
| Date: | 2014-08-21 03:21:56 |
| Message-ID: | CAFS1N4hd+zu=QEO+m6BWS6ZXJuNzF-ak3m3659RQOhoLr0FO9w@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-in-general |
On Thu, Aug 21, 2014 at 1:34 AM, S Ahmed <sahmed1020(at)gmail(dot)com> wrote:
> Hello,
>
> In a Saas application that has 1 database per customer, you may have
> thousands of customers and therefore thousands of databases.
>
> Creating thousands of connection pools is very costly memory wise.
>
> What options are there with the postgres java driver currently?
>
> Say I have 1 server with 500 customer databases on it.
> Can I somehow create 1 connection pool to the server, and then switch to
> the correct database on a per query basis? Or does the driver not support
> this?
>
> Or maybe this isn't a driver specific issue but rather a connection pool
> question?
>
If the database per customer design can be modified, please have a look at
http://www.postgresql.org/docs/current/static/ddl-schemas.html