IPS wrote: > 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 Should not be a problem. The most efficient way is likely to load the whole sheet into a temporary table and run the comparisons completely in the database - that may be what you're doing already. > 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 Not a problem, unless you are on Windows. You can go to thousands of connections - you will loose some efficiency, but it works. The Windows version scales *much* less than the Unix one in this. > 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). You can use cron for this, or you can use "pgagent" which is part of pgAdmin3. //Magnus -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
