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: B Sreejith <bsreejithin(at)gmail(dot)com>
To: Robert Klemme <shortcutter(at)googlemail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org, "sreejith(dot) balakrishnan" <sreejith(dot)balakrishnan(at)tcs(dot)com>
Subject: Re: Any tool/script available which can be used to measure scalability of an application's database.
Date: 2012-07-14 01:26:38
Message-ID: CANVt3iY4ipHJG3+j=c6iO7GDRBT4m-hKAMD=mkf9P8k6q8S_Uw@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
Dear Robert,

We need to scale up both size and load.
Could you please provide steps I need to follow.

Warm regards,
Sreejith.
On Jul 14, 2012 1:37 AM, "Robert Klemme" <shortcutter(at)googlemail(dot)com> wrote:

> 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/
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>

In response to

Responses

pgsql-performance by date

Next:From: Craig RingerDate: 2012-07-14 03:28:26
Subject: Re: query overhead
Previous: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.

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