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

From: Sergey Konoplev <gray(dot)ru(at)gmail(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 18:37:15
Message-ID: CAL_0b1upfYfBdH8E8UVnn2fP2V3BG-shKa_kgzzsEN4180+2Pg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tue, Jul 10, 2012 at 12:21 PM, Sreejith Balakrishnan
<sreejith(dot)balakrishnan(at)tcs(dot)com> wrote:
> Dear @,
>
> 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.

"scalability of an application's database" can be understood either
like a relation of transactions per second to database size or like an
ability of database to be sharded/partitioned or may be like something
else.

Could you please explain more specifically the original task?
What is the goal of it?

> I am a bit confused about the concept of measuring scalability of an
> application's database.
>
> How is the scalability measured?
>
> Is it like loading the DB with a bulk data volume and then do performance
> testing by using tools like JMeter?
>
> Could any one kindly help me on this..
>
> Thanks,
> Sreejith.
>
> =====-----=====-----=====
> Notice: The information contained in this e-mail
> message and/or attachments to it may contain
> confidential or privileged information. If you are
> not the intended recipient, any dissemination, use,
> review, distribution, printing or copying of the
> information contained in this e-mail message
> and/or attachments to it are strictly prohibited. If
> you have received this communication in error,
> please notify us by reply e-mail or telephone and
> immediately and permanently delete the message
> and any attachments. Thank you

--
Sergey Konoplev

a database and software architect
http://www.linkedin.com/in/grayhemp

Jabber: gray(dot)ru(at)gmail(dot)com Skype: gray-hemp Phone: +79160686204

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Claudio Freire 2012-07-13 18:56:50 Re: Poor performance problem with Materialize, 8.4 -> 9.1 (enable_material)
Previous Message Tom Lane 2012-07-13 17:40:57 Re: Poor performance problem with Materialize, 8.4 -> 9.1 (enable_material)