concurrent users

From: IPS <sethi(at)nic(dot)in>
To: pgsql-general(at)postgresql(dot)org
Subject: concurrent users
Date: 2008-12-03 10:03:00
Message-ID: 680ebe5e7fb9e84f.49369fa4@nic.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dear All,<BR>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&nbsp; are getting added&nbsp;every month. I have few queries:<BR>&nbsp;<BR>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<BR>&nbsp;<BR>b. At a given moment,&nbsp;about 100&nbsp;concurrent users are accessing the database for various tasks. What is the level of concurrency one can go for in Postgre<BR>&nbsp;<BR>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).<BR><BR>with regards, <BR><BR>I.P.S. Sethi <BR>

Attachment Content-Type Size
unknown_filename text/html 961 bytes

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dave Page 2008-12-03 10:13:58 Re: concurrent users
Previous Message Enrico Pirozzi 2008-12-03 08:11:24 Re: returns numbers of record