| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Twaha Daudi <uddessy(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Postgresql as main database |
| Date: | 2012-02-23 11:31:10 |
| Message-ID: | 4F46237E.2090201@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Albe Laurenz | 2012-02-23 13:41:28 | Re: Postgresql as main database |
| Previous Message | ultrayoYO | 2012-02-23 11:22:19 | Re: How to enable thread safety on postgresql 8.3.6 |