Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 965A72E02D9 for ; Tue, 18 Mar 2008 05:20:46 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 94502-03 for ; Tue, 18 Mar 2008 05:20:39 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from blu139-omc1-s6.blu139.hotmail.com (blu139-omc1-s6.blu139.hotmail.com [65.55.175.146]) by postgresql.org (Postfix) with ESMTP id EC2E52E02DA for ; Tue, 18 Mar 2008 05:20:37 -0300 (ADT) Received: from BLU110-W11 ([65.55.162.181]) by blu139-omc1-s6.blu139.hotmail.com with Microsoft SMTPSVC(6.0.3790.3959); Tue, 18 Mar 2008 01:20:34 -0700 Message-ID: Content-Type: multipart/related; boundary="_1c9fdaad-3d7e-4f07-bc03-30a52cc6efd5_" X-Originating-IP: [59.160.193.34] From: Vishal Arora To: Suresh Gupta VG , sathiya psql , Subject: Re: postgresql performance tuning tools Date: Tue, 18 Mar 2008 13:50:34 +0530 Importance: Normal In-Reply-To: <3D5445983859B84B92669C0D883EA6FB0CB49031@ZENMAILHQ1.ind.zensar.com> References: <3D5445983859B84B92669C0D883EA6FB0CB49031@ZENMAILHQ1.ind.zensar.com> MIME-Version: 1.0 X-OriginalArrivalTime: 18 Mar 2008 08:20:34.0385 (UTC) FILETIME=[F028F410:01C888D0] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.122 tagged_above=0 required=5 tests=AWL=0.121, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200803/132 X-Sequence-Number: 28615 --_1c9fdaad-3d7e-4f07-bc03-30a52cc6efd5_ Content-Type: multipart/alternative; boundary="_b605ff54-4b81-4377-9692-65fa5920d82b_" --_b605ff54-4b81-4377-9692-65fa5920d82b_ Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Hi Suresh,=20 =20 you can find more about SchemaSpy on the following link - http://schemaspy.= sourceforge.net/ Subject: Re: [ADMIN] postgresql performance tuning toolsDate: Tue, 18 Mar 2= 008 11:13:39 +0530From: suresh.g@zensar.comTo: sathiya.psql@gmail.com; pgsq= l-admin@postgresql.org Hi Sathiya, =20 I am using Solaris-9 and pgsql 8.2.5. Can you pls provide more details of t= his tool, if it can be used for my environment? Pls provide link and docs t= o get more light on this tool. =20 Once again thanks for your information. =20 Regards, G. V. Suresh Gupta ---------------------------------------------------------------------------= ------------------------------------------------------ Innovative Technology Solutions(ITS), Zensar Technologies=20 Zensar Knowledge Park, Plot#5, MIDC IT Tower,=20 Kharadi, Off Nagar Road, Pune =96 411014 Landline : +91-20-66453471 | +91-9890898688 =20 Email : suresh.g@zensar.com | website: www.zensar.com =20 =20 =20 =20 =20 From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql= .org] On Behalf Of sathiya psqlSent: Monday, March 17, 2008 8:49 PMTo: pgsq= l-admin@postgresql.orgSubject: [ADMIN] postgresql performance tuning tools =20 hi all,I want this mail to be continued about summary of performance tuning= tools... or other postgres related tools..I ll start with saying there is = a tool SCHEMASPY ( i got to know about this from another group ), this will= draw ER diagram and gives interesting informations about our postgres data= base..What are all the other opensource tools available like this for seein= g informations about our postgres database... and tools for finetuning our = postgres database....Please join with me and summarize the names and usage = of the tools.... Use SchemaSpy a very easily installable and usable tool...= =20 DISCLAIMER:This email may contain confidential or privileged information fo= r the intended recipient(s) and the views expressed in the same are not nec= essarily the views of Zensar Technologies Ltd. If you are not the intended = recipient or have received this e-mail by error, its use is strictly prohib= ited, please delete the e-mail and notify the sender. Zensar Technologies L= td. does not accept any liability for virus infected mails.=20 _________________________________________________________________ Post free property ads on Yello Classifieds now! www.yello.in http://ss1.richmedia.in/recurl.asp?pid=3D221= --_b605ff54-4b81-4377-9692-65fa5920d82b_ Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable
Hi Suresh,
 
you can find more about SchemaSpy on the following link - http://schemaspy.sourceforge.net/

<= BR>

Subject: Re: [ADMIN] postgresql performance tuning tools
Date: Tue, 18 M= ar 2008 11:13:39 +0530
From: suresh.g@zensar.com
To: sathiya.psql@gma= il.com; pgsql-admin@postgresql.org

Hi Sathiya,

 =

I am using Solaris-9= and pgsql 8.2.5. Can you pls provide more details of this tool, if it can = be used for my environment? Pls provide link and docs to get more light on = this tool.

 =

Once again thanks fo= r your information.

 =

Regards,

G. V. Suresh Gupta

-----------------------------------------------------------------= ----------------------------------------------------------------

Innovative Technology Solutions(ITS), Zen= sar Technologies

Zensar Knowledge Pa= rk, Plot#5, MIDC IT Tower,

Kharadi, Off Nagar Road, Pune =96 411014

Landline :  +91-20-66453471     &nb= sp;     | +91-9890898688     &= nbsp;          

Email     :   sure= sh.g@zensar.com    | website:&nb= sp; www.zensar.com

 

 

 

 

 =


From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgre= sql.org] On Behalf Of sathi= ya psql
Sent: Monday, Ma= rch 17, 2008 8:49 PM
To:= pgsql-admin@postgresql.org
Subject= : [ADMIN] postgresql performance tuning tools

<= /DIV>

 

hi all,
I want this mail to be continued about summ= ary of performance tuning tools... or other postgres related tools..
I ll start with saying there is a tool SCHEMASPY ( i got to know about thi= s from another group ), this will draw ER diagram and gives interesting inf= ormations about our postgres database..


What are all the other o= pensource tools available like this for seeing informations about our postg= res database... and tools for finetuning our postgres database....

P= lease join with me and summarize the names and usage of the tools....
<= BR>Use SchemaSpy a very easily installable and usable tool...


DISCLAIMER:
This email may contain confidential or privileged informatio= n for the intended recipient(s) and the views expressed in the same are not= necessarily the views of Zensar Technologies Ltd. If you are not the inten= ded recipient or have received this e-mail by error, its use is strictly pr= ohibited, please delete the e-mail and notify the sender. Zensar Technologi= es Ltd. does not accept any liability for virus infected mails.


Detailed profiles 4 marriage! Only at Shaadi.com Try it! = --_b605ff54-4b81-4377-9692-65fa5920d82b_-- --_1c9fdaad-3d7e-4f07-bc03-30a52cc6efd5_ Content-Type: image/jpeg Content-Transfer-Encoding: base64 Content-ID: Content-Disposition: attachment; filename="image001.jpg" /9j/4AAQSkZJRgABAgAAZABkAAD/7AARRHVja3kAAQAEAAAAPAAA/+4ADkFkb2JlAGTAAAAAAf/b AIQABgQEBAUEBgUFBgkGBQYJCwgGBggLDAoKCwoKDBAMDAwMDAwQDA4PEA8ODBMTFBQTExwbGxsc Hx8fHx8fHx8fHwEHBwcNDA0YEBAYGhURFRofHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8f Hx8fHx8fHx8fHx8fHx8fHx8f/8AAEQgAZAB9AwERAAIRAQMRAf/EAJMAAQABBQEBAAAAAAAAAAAA AAADAQIEBgcFCAEBAAMBAQEAAAAAAAAAAAAAAAIDBAEFBhAAAgEDAwMDAwIEBAcAAAAAAQIDAAQF ERIGIRMHMUEiURQIYTJxgSMVkUJSFqGCM2MkhBgRAQACAgEDAQYFBQAAAAAAAAABAhEDITESBEFR YYETFAXwcZGhMrHB4SJS/9oADAMBAAIRAxEAPwD6poFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoF AoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFB5mb5NgMHD3svkILFCNVEz hXf9ET9zn9FFQveK9ZaPH8TbunGus2/L+/sWY/Mz5VVmsbaSOwcbkvLlGhZx0I2QOFk0Ovq+3+Br tbZ6O7dEasxaY7vZHP6z0/TL1gNBp6/qakzFAoFBpHmDyXH474kudNol9LLdw2cFtJL2FZ5dzE7w kn7UjY/tq3Tq77YRtOIcZj/MnISa9vils+nrtyTnTX/1a1/Q+9V873OieGfNmV8i5jJWcuBixlpj beOaS5S6a4JkmcrHHtMMWmqxuddfaqN+iNfqnS/c6xvXdt1G71269f8ACsyxWgoXRSAxALHRQTpq f0oOZeWfO2C8f3EWNWzky+emjE4sI3EMcUTMVV55ir7d21tqqrMdOoA61fp8edn5IXvFXKv/AKx5 4kQyMvErY4gkkTg3gjIB0Olz2jEfprpWr6OnTPKHzJfQONzGU5BwG1zNkseKyeWxkd3aCVu9Hby3 MAkj3sVXeELjU7f5V52ysxmI6tWi1IvWbxmmYzjrj1cut/FflrPrpneX9uzbQOkNxNcAj3/pxi2i /wAdawfTbbfyt+P2fXz98+36udOnNvfER+/+0t/4h4l4dxhkuoLY32UTr/c70iaYH6x6jbH/AMgB +pNaNXj0rzjMvD8/735Hk8TPbT/mvEfH2/FuSyRl2jDAyKAWTUagH01H66Ve8hdQKBQKDSvJvlfj Hj/GCfJObnKTqTjsPCR352HTU69I4wf3SN0HtubRTZq1TecQja0Q+aY7fyp525Ussh7WLtnKd7a6 4zHR6AsqDoZ7hgR7721GpSP09HNNFff/AF/wo5vPue55bit/E+Ix/BeG3E1neZmI5Dk2cDbL66SJ u3BEJlIMUe7f8I9NANAfk+6GiPmz3W9OISvPbGIcnu7PhsfHsXNjIcueYicy5W6lhCWfbYMy/avG Wm3o2zRz+75N/pA0xMzac47Vfp6vS8p8ivc/Lx66y7Pc5Gy43Yw3kkpbfJKxmn3Nr13vHLGWJ9T1 qOivbE46ZL2zMLfLXF5eNclGJyGSfMX9ljLNrmWVdn2zmI7bWAbm2xxIq7NNPX+dd0Wi1c4xyXiY nGXTPIvgTyPmBjOTY8DOXl7isbFmLaWdY7tbq3tEhlfWcqkgfZuOrhtxPQ1n1eVWM16RmcJ31TPL WMN5v8u8AuUw2Skaa1wqJBNx/KQRo6QogKxrNGqzL/S07bFnXTQ6MKst4+u8Zj1RrstE4ltfm7N+ KuT84tIMlLnstdWlnBZW+BwUVuEiupHaV43eYydycrIiskCHaV2k66gU+PW9a8Y+Ky8xMuZ4eKfA +UMfb8PXJ4W4OSsbW2t8oFtr5WnkhV4LxIdiMjM56MPkhGorTbFtebY+CuP5cK5e5y2Y8xX+R46p vM1c8hnkwbABtZIrphavo/w2osauS3xAGp6V2sRGvFumOXJmZtw+nPBXibP8DGfu+QX8GRy2dmgl nuYZJpmbtK5ZpZZ1R3dpJnJb3/4V5nkbYvjtjEQ0UrMdXVqoTKBQKDh/mjwRynn3MYc3YZOxs7WC wiskhuFmZyUlllZvh0690D+Va/H8iKVxMKr6+6Wht+InOmAU8hxwUEkKFugAT6nQECtH11fYh8ls dz+KVxccIxlgMxBByfHS3by3YjeW1uIrmTcsThisqmMKu1hrp8hodQRVHmYtn0SnVGMJMR4Z/Ie2 xcGBPkKHG4OBBBCtn3ZZooR0CxSNFBKoVeiju9PQaVy+7VPMV5drW0dZW8w/GzlvJ/Id/wAkvMxY DH3+QinkttkxlFpCY41j1/bv7EQH01pr8qK07YjktrzOZV5/+NvK+XeQMnyOXLWEdhkbmFmtis3d FtDHHDs1A27jHF/DWmryorTHq5bXmcoM9+PflscmzOV41zCOxt8xfXN88UdzkLAg3MrSbWW3Mitt Dbdf0rtPJp2xFo6E0tnhJxD8UrpMzDlea5xMmEmE9xYW6SSfcurBh9xc3DF3UkfNdmrDpups8zjF YwRq5zKFvxn55j/ID5/jnKLWwtzeT3dtkHidr2AXTOZF7JDQSkJKyallDD2HpXfq6zTtmD5c5zCf jv4z8oxnkK25Le5u1yNraX8uQTv95ruaRd72zzyEbWfu9tpNP109q5by4muIgjVzlL4m/G3kvDuc YrkWUy1ldwY1J9IbdZhI0s0DQa6uNNNJWJrm7yotXBXXicvoOsS4oFAoFB4UvGoH5nbch7FvuhsZ rVpSv9fuPJGUIOnoqK6666/LT0JoMXBccv7Dl2eytwkLwZN0e2nVkMqosMMfbYGBZQN0bHTvsvpo o16BThnHb/Dz5Jr23tu7cSs5yUMsjzXgaeaVXuI2RFRkSVVGjN/pGiqooI+EcVzeCh25DIm/f+24 +zVnYN25rRZRKE2xQ6x6yLtZ90h/zH0oMXhPDM/g8Rf4y6vkCta21nibiKSWaSBIrUI24yqm7t3D yds66mMJu6g0FvHeGZix4tm8W4t7GXIwmK1traaWWCKT7Rbd5u46o4aaVTI2i6/5jq5Y0HqZjD5n J8QisJIYFvla1a5smneS3mjt7hJJbd5u2jMk8UZRtY9Du0YFdQQwp+I5VuFWmFJgnlguI5prF5JP tntxcmb7LuMrO0UUREabk0cIAy7SRQS3PG8vPw3C4q4hspcjZTYuW7VGkjtV+yuIpp+xuSV9NsTK itp66EgUEuZ43f3fNMRmkSGazsYZIpEkZA6O7qwkRXgn9FU9Ukjb6kj0B/t3Jjn4zsYhFibQW8zS SGWU6akCFDGrQfIjdpMyN69sP86DZ6BQKBQKDEmy+OguHt5pxHLHH3pA4KhYgGJkZiNoQbTq2ugP T1IoJGvrFAS9xEoGmpLqP3bQvv7710/iPrQR/wB1sRdy2jyGOaHthjIjohMx0jCyMAjlj0AUnr0o Lv7pjfj/AOXD8w7J/UT5LFqJCOvUJp8vpQRRZvFyXEkC3Ee6N449xZQrSTJ3ERDr8mKaN09qCRcr jGkjjW8gMkv/AEkEibm0Yqdo16/JSOnvQWjMYxpFjjuY5ZHVXVI2ViUeTtBxof27+mtBJHkcfI0S x3MTtOXEAV1JcxEiQJoflsI+WnpQR22Xx1yzLFMA6yvBscGNjJGNzBQ4UsNvXVemnWgR5nEyNtS8 gY7o0Gki9WmXfEo69S69V09aCZL2zeRY0njaRy6qgdSSYjpIAAfVD0b6UE1AoFAoFBg3+Htb2XvO zpMsfbjlTbuTSRJVYblYaq8anQ6j6g0GPDxmwhkDK8pRRAEiYqVU25jKkfHXU9hNdT7dNKDJmxFp Nd/dPuMm6Jwuo26wb9nQj/uGgw4eK46OFYmeSbaJAXm2SFu8JA+/chVte82uo6++tBIvHLQLCO9O Whkjk3swZn7SRpo7MpJ3dlSx9dffrQBxvHB7dxv3WqRJGfj6QvvXX4+u71oKW3GrO3ihjWaZxEQS XZSXYXAuQznaOvcB9PYnX2NBW043Y2xt2V5He2OsbuV1PQIAdqr0CKq9Pp11OpoKf7Zx4MOxpIxF NNcsqFQJJZySzyfH5MNdAfXTpQXDjtiAihpAkbRPGnx0VoY+0pHx91A1/h0060F+PwNhYSrLAG3J 3guu30nZGYEgAnTtKAT109daD0aBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKB QKBQKBQKBQKBQKBQKBQKBQKBQKD/2Q== --_1c9fdaad-3d7e-4f07-bc03-30a52cc6efd5_--