Programmers Stack Exchange is a question and answer site for professional programmers interested in conceptual questions about software development. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Is it conceptually feasible to have on a Postgresql Cluster a transactional database and at the same time a datawarehouse that would get feeded by the transactional database ?

share|improve this question
I think this would be more suitable on StackOverflow (please don't repost it there though, it will be automigrated if enough people vote to close it here). – Péter Török Mar 31 '11 at 11:50
@Péter lol i just moved the question here because it was voted for closing on ... StackOverflow ! – Stephan Mar 31 '11 at 11:52
oops. Sometimes it is really difficult for a question to find its place. To me this sounded more like a technical (not subjective) question, but apparently there were at least 5 guys over there who saw it differently. (Nowadays there seem to be lots of people voting to close posts very fast on SO, even for strange reasons, which IMHO is not a good thing...) So let's just keep your question here then, hopefully you will get good answers :-) – Péter Török Mar 31 '11 at 12:08

Yes it is feasible. However, whether it should be done or not would depend on capacity (CPU / and IO) requirements of these two databases.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.