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

2012-07-14 Thread Craig Ringer
On 07/14/2012 08:17 PM, Robert Klemme wrote: On Sat, Jul 14, 2012 at 11:50 AM, B Sreejith 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

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

2012-07-14 Thread Sergey Konoplev
> We have around 15 to 18 separate products.What we are told to do is to check > the scalability of the underlying DB of each product (application). > >> Sounds like your client / boss has a case of buzz-word-itis. "Scalability" >> means lots of different things: Yes, it is still not clear what ex

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

2012-07-14 Thread Robert Klemme
On Sat, Jul 14, 2012 at 11:50 AM, B Sreejith 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

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

2012-07-14 Thread B Sreejith
Dear All, Thanks alot for all the invaluable comments. Regards, Sreejith. On Jul 14, 2012 2:19 PM, "Craig Ringer" wrote: > On 07/14/2012 09:26 AM, B Sreejith wrote: > > Dear Robert, > > We need to scale up both size and load. > Could you please provide steps I need to follow. > > > For load, f

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

2012-07-14 Thread John Jones
Hammerora is a good start but does have some issues when trying to get it started. You can also try PGBench. As someone said, there is a plethora of choices. It all depends on what you want to measure or accomplish. John Jones On Sat, Jul 14, 2012 at 1:48 AM, Craig Ringer wrote: > On 07/14/201

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

2012-07-14 Thread Craig Ringer
On 07/14/2012 09:26 AM, B Sreejith wrote: Dear Robert, We need to scale up both size and load. Could you please provide steps I need to follow. For load, first you need to build a representative sample of your application's querying patterns by logging queries and analysing the logs. Produ