Re: [GENERAL] Postgresql as main database

2012-02-23 Thread Chris Travers
On Thu, Feb 23, 2012 at 2:00 AM, Twaha Daudi  wrote:

> 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?
>

Yes.

As far as implications on performance, it really depends on specifics and I
don't see enough info here to comment.

Best Wishes,
Chris Travers


Re: [GENERAL] Postgresql as main database

2012-02-23 Thread Albe Laurenz
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

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


Re: [GENERAL] Postgresql as main database

2012-02-23 Thread Richard Huxton

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



[GENERAL] Postgresql as main database

2012-02-23 Thread Twaha Daudi
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?
regards
huu