On 1/7/2016 10:32 PM, Sachin Srivastava wrote:
We are looking at more like 500-600 connections simultaneously in 1
day and I want to say we get 1 to 12000 connections a day per db.
these applications, are they hammering queries, or mostly idle, and just
issuing intermittent queries?
500
On Jan 7, 2016, at 10:32 PM, Sachin Srivastava wrote:
>
>
> Dear John,
>
> We are looking at more like 500-600 connections simultaneously in 1 day and I
> want to say we get 1 to 12000 connections a day per db.
Unless you have 300 cores to service those 500-600 simultaneous connections,
Dear John,
We are looking at more like 500-600 connections simultaneously in 1 day
and I want to say we get 1 to 12000 connections a day per db.
Regards
SS
On Fri, Jan 8, 2016 at 10:49 AM, John R Pierce wrote:
> On 1/7/2016 8:21 PM, Sachin Srivastava wrote:
>
> *Q. Total Connection limit f
On Thu, Jan 7, 2016 at 9:21 PM, Sachin Srivastava
wrote:
> Dear David G. and Gavin,
>
> Please find the details as below:
>
>
> * Q. What type of queries to be run on postgres database server? *
>
> All types. Databases will be general OLTP.
>
> *Q. Size of commonly accessed tables, indexes, ...
On 1/7/2016 8:21 PM, Sachin Srivastava wrote:
*Q. Total Connection limit from the database through users and
Application on daily basis for all the database:*
**Probably 4000+
I hope you mean 4000 sessions/day, and not 4000 concurrent connections.
--
john r pierce, recycling bits in san
Dear David G. and Gavin,
Please find the details as below:
* Q. What type of queries to be run on postgres database server? *
All types. Databases will be general OLTP.
*Q. Size of commonly accessed tables, indexes, ... ?*
Various. Anywhere from a few MB to over 100GB.
*Q. Database size fo
On Thu, Jan 7, 2016 at 12:32 AM, Sachin Srivastava
wrote:
> Dear David,
>
>
>
>
>
> Q: RAM holds data that is recently accessed - how much of that will you
> have?
>
>
>
> Ans: Kindly confirm, as per your question “RAM holds data that is recently
> accessed” : How we figured out that how much da
Dear David,
Q: RAM holds data that is recently accessed - how much of that will you
have?
Ans: Kindly confirm, as per your question “RAM holds data that is recently
accessed” : How we figured out that how much data we will have. Is it
depends of Total WAL files (total "checkpoint_segment"
On Wed, Jan 6, 2016 at 10:39 PM, Sachin Srivastava
wrote:
> Dear Team,
>
> Please suggest, how much RAM and core should be define for New Postgres
> database server, if we will use Postgres 9.3 and above.
>
> If suppose my postgres database size will be near about 300 to 500 GB for
> future.
>
>
On 07/01/16 18:39, Sachin Srivastava wrote:
Dear Team,
Please suggest, how much RAM and core should be define for New
Postgres database server, if we will use Postgres 9.3 and above.
If suppose my postgres database size will be near about 300 to 500 GB
for future.
There is any document reg
10 matches
Mail list logo
