both of the two database are live but use for two different web app.
my company don't want to spend more to buy a new server, so then I think of
to implement both under the same server and one instance..
but then my superior don't want to do that way.
they want to implement two databases in o
so what is the best way to implement two databases in one machine?
implement with two postgresql instances with separate directory or
implement under one instance?
if I implement two database in one instance, if one of the database crash
will it affect the other?
Hi,
Is it possible to start two instances of postgresql with different port and
directory which run simultaneously?
If can then will this cause any problem or performance drop down?
Thanks.
---(end of broadcast)---
TIP 1: if posting/reading th
Hi,
Currently I'm using postgresql v8.1.3 and the latest jdbc.
I try to open a JReports' report and the time taken to completely open the
report is 137453ms.
Then I open the same report but this time I connect to postgresql v7.2.2
but the completion time is even faster than connect to postgre
Actually now I already work to upgrade Postgresql version to 8.1 but not
yet finish.
Yesterday I did re-create the affected tables indices, it does improve the
performance but still need 2-5 mins to execute the query.
Is this 'normal' for a table with 40K rows of records?
Anyway thanks for yo
I'm facing a very weird problem.
Recently our database run very slow when execute Delete/Select statement
for a few tables only..
The largest table only have 50K rows of data.
When I run the statement from pgAdmin although it is slow but not as slow
as run from webapp.
When I run the statement
