pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedWhat is the max number of database I can create in an instance of pgsql?
4+ messages / 4 participants
[nested] [flat]
* What is the max number of database I can create in an instance of pgsql?
@ 2005-11-19 03:24 anon permutation <anonpermutation@hotmail.com>
2005-11-19 03:49 ` Re: What is the max number of database I can create in an instance of pgsql? Michael Glaesemann <grzm@myrealbox.com>
2005-11-19 04:55 ` Re: What is the max number of database I can create in an instance of pgsql? Jaime Casanova <systemguards@gmail.com>
0 siblings, 2 replies; 4+ messages in thread
From: anon permutation @ 2005-11-19 03:24 UTC (permalink / raw)
To: pgsql-performance
Hi,
We want to create a database for each one of our departments, but we only
want to have one instance of postgresql running. There are about 10-20
departments. I can easily use createdb to create these databases. However,
what is the max number of database I can create before performance goes
down?
Assuming each database is performing well alone, how would putting 10-20 of
them together in one instance affect postgres?
In terms of getting a new server for this project, how do I gauge how
powerful of a server should I get?
Thanks.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: What is the max number of database I can create in an instance of pgsql?
2005-11-19 03:24 What is the max number of database I can create in an instance of pgsql? anon permutation <anonpermutation@hotmail.com>
@ 2005-11-19 03:49 ` Michael Glaesemann <grzm@myrealbox.com>
2005-11-19 13:45 ` Re: What is the max number of database I can create in John McCawley <nospam@hardgeus.com>
1 sibling, 1 reply; 4+ messages in thread
From: Michael Glaesemann @ 2005-11-19 03:49 UTC (permalink / raw)
To: anon permutation <anonpermutation@hotmail.com>; +Cc: pgsql-performance
On Nov 19, 2005, at 12:24 , anon permutation wrote:
> However, what is the max number of database I can create before
> performance goes down?
>
> Assuming each database is performing well alone, how would putting
> 10-20 of them together in one instance affect postgres?
>
> In terms of getting a new server for this project, how do I gauge
> how powerful of a server should I get?
I'm sure those wiser than me will chime in with specifics. I think
you should be think of usage not in terms of number of databases but
in terms of connections rates, database size (numbers of tables and
tuples) and the types of queries that will be run. While there may be
a little overhead in from having a number of databases in the
cluster, I think this is probably going to be insignificant in
comparison to these other factors. A better idea of what the usage
will guide you in choosing your hardware.
Michael Glaesemann
grzm myrealbox com
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: What is the max number of database I can create in
2005-11-19 03:24 What is the max number of database I can create in an instance of pgsql? anon permutation <anonpermutation@hotmail.com>
2005-11-19 03:49 ` Re: What is the max number of database I can create in an instance of pgsql? Michael Glaesemann <grzm@myrealbox.com>
@ 2005-11-19 13:45 ` John McCawley <nospam@hardgeus.com>
0 siblings, 0 replies; 4+ messages in thread
From: John McCawley @ 2005-11-19 13:45 UTC (permalink / raw)
To: pgsql-performance
>> However, what is the max number of database I can create before
>> performance goes down?
>
I know I'm not directly answering your question, but you might want to
consider why you're splitting things up into different logical
databases. If security is a big concern, you can create different
database users that own the different departments' tables, and each of
your apps can login as the corresponding users.
Everyone loves reports. Once you've got data in your database, people
will ask for a billion reports...Whether or not they know it now, most
likely they're going to want reports that cross the department
boundaries (gross revenue, employee listings etc.) and that will be very
difficult if you have multiple databases.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: What is the max number of database I can create in an instance of pgsql?
2005-11-19 03:24 What is the max number of database I can create in an instance of pgsql? anon permutation <anonpermutation@hotmail.com>
@ 2005-11-19 04:55 ` Jaime Casanova <systemguards@gmail.com>
1 sibling, 0 replies; 4+ messages in thread
From: Jaime Casanova @ 2005-11-19 04:55 UTC (permalink / raw)
To: anon permutation <anonpermutation@hotmail.com>; +Cc: pgsql-performance
On 11/18/05, anon permutation <anonpermutation@hotmail.com> wrote:
>
> Hi,
>
> We want to create a database for each one of our departments, but we only
> want to have one instance of postgresql running. There are about 10-20
> departments. I can easily use createdb to create these databases. However,
>
After of doing this, you have to think if you will want to make querys
across the info of some or all databases (and you will) if that is the
case the better you can do is create schemas instead of databases...
> what is the max number of database I can create before performance goes
> down?
>
the problem isn't about number of databases but concurrent users...
after all you will have the same resources for 1 or 100 databases, the
important thing is the number of users, the amount of data normal
users will process in a normal day, and complexity of your queries.
> Assuming each database is performing well alone, how would putting 10-20 of
>
> them together in one instance affect postgres?
>
> In terms of getting a new server for this project, how do I gauge how
> powerful of a server should I get?
>
> Thanks.
>
>
--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2005-11-19 13:45 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-11-19 03:24 What is the max number of database I can create in an instance of pgsql? anon permutation <anonpermutation@hotmail.com>
2005-11-19 03:49 ` Michael Glaesemann <grzm@myrealbox.com>
2005-11-19 13:45 ` Re: What is the max number of database I can create in John McCawley <nospam@hardgeus.com>
2005-11-19 04:55 ` Jaime Casanova <systemguards@gmail.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