Skip site navigation (1) Skip section navigation (2)

Re: Any tool/script available which can be used to measure scalability of an application's database.

From: Robert Klemme <shortcutter(at)googlemail(dot)com>
To: Sreejith Balakrishnan <sreejith(dot)balakrishnan(at)tcs(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Any tool/script available which can be used to measure scalability of an application's database.
Date: 2012-07-13 20:06:55
Message-ID: CAM9pMnMcsU0qWb_a2xPHdJ5oobscptE5votqY2T95GnRw7c=pA@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Tue, Jul 10, 2012 at 10:21 AM, Sreejith Balakrishnan
<sreejith(dot)balakrishnan(at)tcs(dot)com> wrote:
> Is there any tool or some sort of script available, for PostgreSQL, which
> can be used to measure scalability of an application's database. Or is there
> any guideline on how to do this.
>
> I am a bit confused about the concept of measuring scalability of an
> application's database.

You cannot measure scalability of a database as such.  You need to
know the nature of the load (i.e. operations executed against the DB -
how many INSERT, UPDATE, DELETE and SELECT, against which tables and
with what frequency and criteria).  And then, as Sergey said, you need
to define whether you want to scale up the load or the size - or both.

Kind regards

robert

-- 
remember.guy do |as, often| as.you_can - without end
http://blog.rubybestpractices.com/

In response to

Responses

pgsql-performance by date

Next:From: B SreejithDate: 2012-07-14 01:21:07
Subject: Re: Any tool/script available which can be used to measure scalability of an application's database.
Previous:From: Claudio FreireDate: 2012-07-13 18:56:50
Subject: Re: Poor performance problem with Materialize, 8.4 -> 9.1 (enable_material)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group