From: Amit Sharma <asharma@verts.co.in>
To: Kevin Grittner <kgrittn@ymail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: PostgreSQL db
Date: Wed, 11 Jun 2014 10:39:09 -0700 (PDT)
Message-ID: <26995497.123.1402508346235.JavaMail.lenovo@lenovo-PC> (raw)
In-Reply-To: <1402507690.19836.YahooMailNeo@web122306.mail.ne1.yahoo.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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@ymail.com>
To: "Amit Sharma" <asharma@verts.co.in>, pgsql-admin@postgresql.org
Sent: Wednesday, June 11, 2014 10:28:10 AM
Subject: Re: [ADMIN] PostgreSQL db
Amit Sharma <asharma@verts.co.in> 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
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: asharma@verts.co.in, kgrittn@ymail.com
Subject: Re: PostgreSQL db
In-Reply-To: <26995497.123.1402508346235.JavaMail.lenovo@lenovo-PC>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox