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" <shortcut...@googlemail.com> wrote: > On Tue, Jul 10, 2012 at 10:21 AM, Sreejith Balakrishnan > <sreejith.balakrish...@tcs.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@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance >
