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
by 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
by 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]
Users browsing this forum: No registered users and 13 guests