We need to scale up both size and load.
Could you please provide steps I need to follow.
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
> > 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
> remember.guy do |as, often| as.you_can - without end
> Sent via pgsql-performance mailing list (pgsql-performance(at)postgresql(dot)org)
> To make changes to your subscription:
In response to
pgsql-performance by date
|Next:||From: Craig Ringer||Date: 2012-07-14 03:28:26|
|Subject: Re: query overhead|
|Previous:||From: B Sreejith||Date: 2012-07-14 01:21:07|
|Subject: Re: Any tool/script available which can be used to measure
scalability of an application's database.|