concurrent users
| От | IPS |
|---|---|
| Тема | concurrent users |
| Дата | |
| Msg-id | 680ebe5e7fb9e84f.49369fa4@nic.in обсуждение исходный текст |
| Ответы |
Re: concurrent users
Re: concurrent users |
| Список | pgsql-general |
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
В списке pgsql-general по дате отправления: