Hi Tarun,
The strategy of employing dual servers to divide your data is a short term
arrangement. Lot of performance related issues *will* crop up in the future and lot of
fingers would be raised on you.
Switch to a solution like > SQL Server. Savings on $$ by employing a freeware like
PostgreSQL is fine but look at other aspects as well.
You can't match optimizer of PostgreSQL vis-a-vis Oracle. Oracle is far ahead!
Anyway Best of Luck, Just do let me know how much you successeded.
Regards,
Gurpreet Singh Sachdeva
-----Original Message-----
From: Tarun Upadhyay [mailto:[EMAIL PROTECTED]
Sent: Sat 10/11/2003 10:26 AM
To: 'The Linux-Delhi mailing list'
Cc:
Subject: RE: [ilugd] Postgres vs oracle
Gupreet,
It is a real application. It's an OLTP appliaction for banking and
credit card industry. From a concurrency point of view, I expect about 200
connections to the database in the worst case and a fifth of that on the
average.
however, if postgres cannot handle that kind of user connections;
that is fine too. I just need to know the number it can handle and then I
will find a way of dividing the data over 2 or more servers such that each
gets lesser load.
A little off-topic, but
A little research on the web mentions that Postgres Query optimizer
is weak and in general one should optimize the queries by hand (we have to
do the same for oracle anyway. For that kind of database size, I do not
trust the query optimizer any way). Is that true?
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On
Behalf Of Gurpreet Singh Sachdeva
Sent: Saturday, October 11, 2003 2:32 AM
To: The Linux-Delhi mailing list; The Linux-Delhi mailing list
Subject: RE: [ilugd] Postgres vs oracle
Hi Tarun,
I think you are trying to compare a Apple with a Water Melon.
But any case if you are really facing a real time scenario, please make it
clear. what exactly the application you are running and how many concurrent
user you are expecting to be there as concurrency is a major factor which
can cause ample amount of problems for the DBA. I make sure that I would be
able to solve all your queries. Regards, Gurpreet Singh Sachdeva
-----Original Message-----
From: Tarun Upadhyay [mailto:[EMAIL PROTECTED]
Sent: Fri 10/10/2003 9:50 PM
To: 'The Linux-Delhi mailing list'
Cc:
Subject: [ilugd] Postgres vs oracle
We have a customer application on oracle.
They want to crate a "small footprint" version of it to be sold at a
cheaper
price.
I want to suggest that Postgres could be the right choice of
database for
that as it is close to oracle in its sql syntax and hence porting
should be
simpler.
Can anybody guide me on what kind of pitfalls we could run into by
choosing
Postgres. The database is not very large but is much larger than
what goes
for "database" in mysql discussions (about 1 GB of data, 100 tables
with
about 10-50 MB added every day)?
In particular, I would be interested in hearing from people who have
run
moderately large databases on postgres and how fast they found it.
I have heard that it is possible to now provide replication and fail
over
with postgres. Has anybody tried it?
Tarun
_______________________________________________
ilugd mailing list
[EMAIL PROTECTED]
http://frodo.hserus.net/mailman/listinfo/ilugd
_______________________________________________
ilugd mailing list
[EMAIL PROTECTED]
http://frodo.hserus.net/mailman/listinfo/ilugd
_______________________________________________
ilugd mailing list
[EMAIL PROTECTED]
http://frodo.hserus.net/mailman/listinfo/ilugd
