Dear All,I am planning to migrate my database from Oracle 10g to Postgre SQL. The database in Oracle currently have
about21 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
withmaster database (21 million records) and giving matching and not matching numbers. Average of 1800 comparisions are
happeningevery day. I am concerned with performance of oracle vs postgre b. At a given moment, about
100 concurrentusers are accessing the database for various tasks. What is the level of concurrency one can go for
inPostgre 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