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

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
>