Re: concurrent users

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: IPS <sethi(at)nic(dot)in>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: concurrent users
Date: 2008-12-03 10:25:14
Message-ID: 49365E8A.2010909@hagander.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2008-12-03 11:31:23 Re: returns numbers of record
Previous Message Dave Page 2008-12-03 10:13:58 Re: concurrent users