Dear All,
I am planning to migrate my database from Oracle 10g to Postgre SQL. The database in Oracle currently have about 21 million records and about 2 million new record are getting added every month. I have few queries:
a. I get the data from user in excel/csv file (maximum 130000 records per file). Compare the data in file with master database (21 million records) and giving matching and not matching numbers. Average of 1800 comparisions are happening every day. I am concerned with performance of oracle vs postgre
b. At a given moment, about 100 concurrent users are accessing the database for various tasks. What is the level of concurrency one can go for in Postgre
c. In orcale jobs are scheduled and executed in the database directly. In postgre no such facility is available. I need to run a job every 2 minutes (24 X 7 operations).
with regards,
I.P.S. Sethi
