Thread: Postgresql as main database

Hello all,

Hello all,

 Good day,

I would like to make  Postgresql 8.4 as main database for running three(software) and possible exchanging data.Is it possible? if yes what is the implication in terms of performance?

It's certainly possible. Obviously it will need a bigger machine than you would use for just one of the databases.

Bear in mind that you can't have cross-database queries without using something like the dblink package. I don't know if that affects your "exchanging data".

Oh - and unless you really have no choice in the matter, use 9.1 rather than 8.4 - you will get better performance, new features and it will be supported for longer.

--  Richard Huxton Archonet Ltd

Twaha Daudi wrote:
> I would like to make  Postgresql 8.4 as main database for running
three(software) and possible
> exchanging data.Is it possible? if yes what is the implication in
terms of performance?

Please give us more information:
- What is three(software)?
- Can you specify how and with what you would like to exchange data?
- The implications of what compared to what?

Yours,
Laurenz Albe