pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedlarge database versus many databases
4+ messages / 4 participants
[nested] [flat]
* large database versus many databases
@ 2005-03-18 14:27 Uwe Maiwald <u.maiwald@kiss-net.de>
2005-03-18 16:07 ` Re: large database versus many databases Tom Lane <tgl@sss.pgh.pa.us>
2005-03-18 16:16 ` Re: large database versus many databases Sabio - PSQL <slopez_pg@ceroriesgo.co.cr>
0 siblings, 2 replies; 4+ messages in thread
From: Uwe Maiwald @ 2005-03-18 14:27 UTC (permalink / raw)
To: pgsql-admin
Hi,
we are currently planning a very large installation of a web-application
using PostgreSQL. The application can be configured to handle 1 database
per customer, or all customers in one large database.
We plan to start with e.g. 500 customers, each of which can have 200 MB or
more in the database. And we want the system to be expandable as needed
(thousands of customers, using lots of memory).
Has anyone any experience what is best
- using one very large database for all customers or
- using 1 database per customer
concerning expandability, performance, server configuration, system updates
etc.
Is it advisable not to install more than a certain amount of databases on
one server?
Any hints welcome,
Thanks, Uwe
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: large database versus many databases
2005-03-18 14:27 large database versus many databases Uwe Maiwald <u.maiwald@kiss-net.de>
@ 2005-03-18 16:07 ` Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 0 replies; 4+ messages in thread
From: Tom Lane @ 2005-03-18 16:07 UTC (permalink / raw)
To: Uwe Maiwald <u.maiwald@kiss-net.de>; +Cc: pgsql-admin
Uwe Maiwald <u.maiwald@kiss-net.de> writes:
> we are currently planning a very large installation of a web-application
> using PostgreSQL. The application can be configured to handle 1 database
> per customer, or all customers in one large database.
> We plan to start with e.g. 500 customers, each of which can have 200 MB or
> more in the database. And we want the system to be expandable as needed
> (thousands of customers, using lots of memory).
The one-big-database approach would scale better, but is performance
your only consideration? Separate databases would enforce strict
separation between customers, which might be either a good thing or
a bad thing depending on your needs.
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: large database versus many databases
2005-03-18 14:27 large database versus many databases Uwe Maiwald <u.maiwald@kiss-net.de>
@ 2005-03-18 16:16 ` Sabio - PSQL <slopez_pg@ceroriesgo.co.cr>
2005-03-19 06:08 ` Re: large database versus many databases Adrian Engelbrecht <adrianengelbrecht@hotmail.com>
1 sibling, 1 reply; 4+ messages in thread
From: Sabio - PSQL @ 2005-03-18 16:16 UTC (permalink / raw)
To: pgsql-admin
Uwe Maiwald wrote:
> Hi,
>
> we are currently planning a very large installation of a
> web-application using PostgreSQL. The application can be configured to
> handle 1 database per customer, or all customers in one large database.
>
> We plan to start with e.g. 500 customers, each of which can have 200
> MB or more in the database. And we want the system to be expandable as
> needed (thousands of customers, using lots of memory).
>
> Has anyone any experience what is best
> - using one very large database for all customers or
> - using 1 database per customer
>
> concerning expandability, performance, server configuration, system
> updates etc.
>
> Is it advisable not to install more than a certain amount of databases
> on one server?
>
> Any hints welcome,
>
> Thanks, Uwe
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>
I am currently developing a system like this and we are using one
database per customer.
You only have to consider one thing.
If you have only one database for all customer and database have a
problem all customer can't work.
If you have many databases as customers if a database fails only one
customer can't work, and it's easier to solve for one that for all.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: large database versus many databases
2005-03-18 14:27 large database versus many databases Uwe Maiwald <u.maiwald@kiss-net.de>
2005-03-18 16:16 ` Re: large database versus many databases Sabio - PSQL <slopez_pg@ceroriesgo.co.cr>
@ 2005-03-19 06:08 ` Adrian Engelbrecht <adrianengelbrecht@hotmail.com>
0 siblings, 0 replies; 4+ messages in thread
From: Adrian Engelbrecht @ 2005-03-19 06:08 UTC (permalink / raw)
To: slopez_pg@ceroriesgo.co.cr; pgsql-admin
<html><div style='background-color:'><P>With many databases (instead of one large database) you can move them around as resources before scarce, ie: to other servers or expanded disk. The down side is there will be many to be maintained, but automated scripts should take care of most of that.</P>
<P><BR><BR> </P><BR><BR><BR>
<DIV>
<P>Adrian</P>
<P>ICQ 120480893</P>
<P><A href="https://www.paypal.com/refer/pal=N6T2FQ7WRPHH4">https://www.paypal.com/refer/pal=N6T2FQ7WRPHH...: Sabio - PSQL <slopez_pg@ceroriesgo.co.cr> To: PostgreSQL Admin <pgsql-admin@postgresql.org> Subject: Re: [ADMIN] large database versus many databases Date: Fri, 18 Mar 2005 10:16:45 -0600 Uwe Maiwald wrote: >Hi, > >we are currently planning a very large installation of a >web-application using PostgreSQL. The application can be configured >to handle 1 database per customer, or all customers in one large >database. > >We plan to start with e.g. 500 customers, each of which can have 200 >MB or more in the database. And we want the system to be expandable >as needed (thousands of customers, using lots of memory). > >Has anyone any experience what is best >- using one very large database for all customers or >-
using 1 database per customer > >concerning expandability, performance, server configuration, system >updates etc. > >Is it advisable not to install more than a certain amount of >databases on one server? > >Any hints welcome, > >Thanks, Uwe > > >---------------------------(end of >broadcast)--------------------------- >TIP 6: Have you searched our list archives? > > http://archives.postgresql.org > > I am currently developing a system like this and we are using one database per customer. You only have to consider one thing. If you have only one database for all customer and database have a problem all customer can't work. If you have many databases as customers if a database fails only one customer can't work, and it's easier to solve for one that for all. ---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly </div><br clear=all><hr>Need more speed? Get <a href="http://g.msn.com/8HMBENNZ/2755??PS=47575"; target="_top">Xtra Broadband!</a> </html>
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2005-03-19 06:08 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-03-18 14:27 large database versus many databases Uwe Maiwald <u.maiwald@kiss-net.de>
2005-03-18 16:07 ` Tom Lane <tgl@sss.pgh.pa.us>
2005-03-18 16:16 ` Sabio - PSQL <slopez_pg@ceroriesgo.co.cr>
2005-03-19 06:08 ` Adrian Engelbrecht <adrianengelbrecht@hotmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox