Multiple databases slower than one?

PostgreSQL is the database server used to store information. Do you have a question or are you having problem with PostgreSQL? If so, post them here.

Moderator: Moderators

Multiple databases slower than one?

Postby sethseth » Wed Oct 05, 2011 8:51 am

I run about 6 different databases because I like to do housekeeping in smaller chunks, rather than have a cache update that takes most of a day. Can this cause a significant performance decrease over running just 2? What if I ran 15 databases, should this matter at all?
sethseth
 
Posts: 16
Joined: Mon Apr 21, 2008 5:31 am

Re: Multiple databases slower than one?

Postby kraada » Wed Oct 05, 2011 9:02 am

The more databases you have the more data that must be amalgamated and the more connection processes that must be kept open. If you have a sufficiently powerful computer you will probably not notice a difference, but we have never done internal testing on as many databases as you propose so I cannot say the extent of the performance decrease that you would experience.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 27 guests

cron
highfalutin