Hi Kevin, Thanks for the prompt reply. May I know the machine configuration esp. the hardware configuration that you used for this setup? Thanks Amit ----- Original Message ----- From: "Kevin Grittner" <kgrittn@xxxxxxxxx> To: "Amit Sharma" <asharma@xxxxxxxxxxx>, pgsql-admin@xxxxxxxxxxxxxx Sent: Wednesday, June 11, 2014 10:28:10 AM Subject: Re: [ADMIN] PostgreSQL db Amit Sharma <asharma@xxxxxxxxxxx> wrote: > Hope I am not bothering you by sending this email. I had some > query regarding Postgres & while doing research online I got your > reference. We are using OpenERP an opensource ERP system. For one > installation it require that there will be 3000 simultaneous > users accessing OpenERP server, hence same requests will come to > PostgreSQL server. And daily 500,000 (Half million)records will > be added that means 15,000,000 (15 Million) a month. > > Can Postgres handle 3000 simultaneous requests and handled > 15million records addition month on month basis. With this growth > can Postgresql handle the volume for next 10 years or so? Any > recommendation on Server configuration; we will be using Amazon > Cloud. People often run much larger volumes than this on PostgreSQL, but generally not without using connection pooling. http://wiki.postgresql.org/wiki/Number_Of_Database_Connections Personally, I managed a machine which typically had 3000 users running queries against it while about 20 million INSERT/UPDATE/DELETE statements per day were run against it. Tuning showed best performance when we used connection pools with 35 connections for read-only queries and 6 connections for the DML. Expect to spend some time adjusting the configuration for your particular hardware and workload. -- Kevin Grittner EDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com
