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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Craig Ringer | 2012-07-14 03:28:26 | Re: query overhead |
Previous Message | B Sreejith | 2012-07-14 01:21:07 | Re: Any tool/script available which can be used to measure scalability of an application's database. |