From: Tomas Vondra <tv@fuzzy.cz>
To: pgsql-performance@postgresql.org
Subject: Re: Postgresql 9.3 for a Mobile Backend
Date: Fri, 09 May 2014 00:59:37 +0200
Message-ID: <536C0C59.2000309@fuzzy.cz> (raw)
In-Reply-To: <005b01cf6a8c$9346a540$b9d3efc0$@pinelabs.com>
References: <005b01cf6a8c$9346a540$b9d3efc0$@pinelabs.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
On 8.5.2014 09:10, Rajiv Kasera wrote:
> Dear Community friends,
>
>
>
> We are planning to use postgresql 9.3 for building a mobile backend. Can
> we get a benchmark on the level of concurrency that can be supported by
> Postgres 9.3 and it will be able to handle the spike in traffic if the
> app gets popular.
I'm afraid the only answer we can give you is 'that depends ...' :-(
Three most important things you need to know before answering the
questions is;
1) dataset - How much data are we talking about? Is only small part
active? Is it static / does it change a lot? Etc.
2) workload - Are you doing simple or complex queries? What portion of
the workload is read-only?
3) hardware - CPUs, drives, ...
There's no way to answer the question without answering these questions
first. There are databases that promise you everything without asking
you these questions - treat them just like Ulysses approached sirens.
I understand these questions are difficult to answer before the project
even started, but you certainly have an idea how it's going to work so
do estimates and review them as the project progresses.
regards
Tomas
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
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-performance@postgresql.org
Cc: tv@fuzzy.cz
Subject: Re: Postgresql 9.3 for a Mobile Backend
In-Reply-To: <536C0C59.2000309@fuzzy.cz>
* 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