Skip site navigation (1) Skip section navigation (2)

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

From: Robert Klemme <shortcutter(at)googlemail(dot)com>
To: pgsql-performance <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-14 12:17:48
Message-ID: CAM9pMnPTF-MQCdM7BE45gWS_zMTGX1jNev0EGNXgSjCdMLJizw@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Sat, Jul 14, 2012 at 11:50 AM, B Sreejith <bsreejithin(at)gmail(dot)com> wrote:
> Dear All,
> Thanks alot for all the invaluable comments.

Additionally to Craig's excellent advice to measurements there's
something else you can do: with the knowledge of the queries your
application fires against the database you can evaluate your schema
and index definitions.  While there is no guarantee that your
application will scale well if all indexes are present you believe
need to be present based on that inspection, you can pretty easily
identify tables with can be improved.  These are tables which a) are
known to grow large and b) do not have indexes nor no indexes which
support the queries your application does against these tables which
will result in full table scans.  Any database which scales in size
will sooner or later hit a point where full table scans of these large
tables will be extremely slow.  If these queries are done during
regular operation (and not nightly maintenance windows for example)
then you pretty surely have identified a show stopper.

Kind regards

robert

-- 
remember.guy do |as, often| as.you_can - without end
http://blog.rubybestpractices.com/

In response to

Responses

pgsql-performance by date

Next:From: Sergey KonoplevDate: 2012-07-14 12:49:43
Subject: Re: Any tool/script available which can be used to measure scalability of an application's database.
Previous:From: B SreejithDate: 2012-07-14 09:50:01
Subject: Re: Any tool/script available which can be used to measure scalability of an application's database.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group