Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 3298F2E331E for ; Wed, 2 Jan 2008 14:49:04 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 27180-05 for ; Wed, 2 Jan 2008 14:48:57 -0400 (AST) Received: from eciweb.eldocomp.com (eciweb.eldocomp.com [205.159.99.28]) by postgresql.org (Postfix) with ESMTP id 1B26C2E30CE for ; Wed, 2 Jan 2008 14:48:58 -0400 (AST) Received: from ecimail.eldocomp.com [172.20.128.2] by eciweb.eldocomp.com with XWall v3.38 ; Wed, 2 Jan 2008 11:48:45 -0700 Received: from [127.0.0.1] ([172.20.131.10]) by ecimail.eldocomp.com with Microsoft SMTPSVC(6.0.3790.1830); Wed, 2 Jan 2008 11:48:44 -0700 References: <3D51BC79-C289-4B35-B1B1-078F82D00A1A@indiana.edu> <1D47EBB7CD93C241A0A0685375B46DF406E224E5@NYWEXMB50.msad.ms.com> In-Reply-To: <1D47EBB7CD93C241A0A0685375B46DF406E224E5@NYWEXMB50.msad.ms.com> From: Naomi Walker To: "Sattler, Thomas (IT)" Cc: Carol Walter , "pgsql-admin@postgresql.org" Subject: Re: Performance tuning... Date: Wed, 2 Jan 2008 11:48:44 -0700 X-Assembled-By: XWall v3.38 Message-ID: <477BDC8C.6080603@mhs.mphasis.com> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="_NextPart_1_qmZrHLajoetbkwlTZTViemHPfyb" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/28 X-Sequence-Number: 27802 This is a multi part MIME message. --_NextPart_1_qmZrHLajoetbkwlTZTViemHPfyb Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Sattler, Thomas (IT) wrote: > Cache, cache, cache, cache. > =20 and consider dropping all indices until after the load is completed.. > > Thomas Sattler > Morgan Stanley | Technology > 750 Seventh Avenue, 14th Floor | New York, NY 10019 > Phone: +1 212 762-1212 > Thomas.Sattler@morganstanley.com > =20 > > =20 >> -----Original Message----- >> From: pgsql-admin-owner@postgresql.org=20 >> [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Carol Walter >> Sent: Wednesday, January 02, 2008 10:35 AM >> To: pgsql-admin@postgresql.org >> Subject: [ADMIN] Performance tuning... >> >> Greetings and Salutations... >> >> This has probably been discussed a number of times, but I=20 >> really need your help. I am upgrading from 8.1 to 8.2. =20 >> Right now I have the restore of the database to the new=20 >> version running. It has been running since December 21, at=20 >> 4:30 PM. I'm in a University environment and we're in the=20 >> midst of winter break, so there is very little processing=20 >> going on on my systems. This is actually a test run of the=20 >> upgrade. I thought I would be able to do the test and live=20 >> during the break but as slow as this thing is going, I may be=20 >> lucky just to finish the test. This brings me to my question. Is =20 >> there any performance tuning I can do to make this think run=20 >> faster? =20 >> This is a Sun box running Solaris 10. >> >> Carol >> >> ---------------------------(end of=20 >> broadcast)--------------------------- >> TIP 1: if posting/reading through Usenet, please send an appropriate >> subscribe-nomail command to majordomo@postgresql.org=20 >> so that your >> message can get through to the mailing list cleanly >> >> =20 > -------------------------------------------------------- > > NOTICE: If received in error, please destroy and notify sender. Sender doe= s not intend to waive confidentiality or privilege. Use of this email is pro= hibited when received in error. > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org > =20 --=20 ------------------------------------------------------------------------ Naomi Walker Chief Information Officer Mphasis Healthcare Solutions nwalker@mhs.mphasis.com =20 ---An EDS Company 602-604-3100 ------------------------------------------------------------------------ Excellence is not a skill. It is an attitude. --Ralph Marston ------------------------------------------------------------------------ -- CONFIDENTIALITY NOTICE -- Information transmitted by this=C2=A0e-mail is proprietary to MphasiS and/or= its Customers and is intended for use only by the individual or entity to w= hich it is addressed, and may contain information that is=C2=A0privileged, c= onfidential or exempt from disclosure under applicable law. If you are not t= he intended recipient or it appears that this e-mail has been forwarded to y= ou without proper authority, you are notified that any use or dissemination = of this information in any manner is strictly prohibited. In such cases, ple= ase notify us immediately at mailmaster@mphasis.com and delete this mail fro= m your records. --_NextPart_1_qmZrHLajoetbkwlTZTViemHPfyb Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable =20 Sattler, Thomas (IT) wrote:
=20
Cache, cache, cache, cache.
=20 
and consider dropping all indices until after the load is completed..
=20

Thomas Sattler
Morgan Stanley | Technology
750 Seventh Avenue, 14th Floor | New York, NY  10019
Phone: +1 212 762-1212
Thomas.Sattler@morganstanley.com
=20

=20 
=20
=20
-----Original Message-----
From: pgsql-admin-owner@postgresql.org=20
[mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Carol Wal=
ter
Sent: Wednesday, January 02, 2008 10:35 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Performance tuning...

Greetings and Salutations...

This has probably been discussed a number of times, but I=20
really need your help.  I am upgrading from 8.1 to 8.2. =20
Right now I have the restore of the database to the new=20
version running.  It has been running since December 21, at=20
4:30 PM.  I'm in a University environment and we're in the=20
midst of winter break, so there is very little processing=20
going on on my systems.  This is actually a test run of the=20
upgrade.  I thought I would be able to do the test and live=20
during the break but as slow as this thing is going, I may be=20
lucky just to finish the test.  This brings me to my question.  Is =20
there any performance tuning I can do to make this think run=20
faster?  =20
This is a Sun box running Solaris 10.

Carol

---------------------------(end of=20
broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
=20      subscribe-nomail command to majordomo@postgresql.org=20
so that your
=20      message can get through to the mailing list cleanly

=20   
=20
=20
--------------------------------------------------=
------

NOTICE: If received in error, please destroy and notify sender. Sender does =
not intend to waive confidentiality or privilege. Use of this email is prohi=
bited when received in error.

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

=20              http://archives.postgresql.org
=20 


--=20
------------------------------------------------------------------------
Naomi Walker                          Chief Information Officer
Mphasis Healthcare Solutions          nwalker@mhs.mphasis.com
=20 ---An EDS Company                   602-604-3100
------------------------------------------------------------------------
Excellence is not a skill. It is an attitude.   --Ralph Marston
------------------------------------------------------------------------











-- CONFIDENTIALITY NOTICE --







-- CONFIDENTIALITY NOTICE --

Info= rmation transmitted by this=A0e-mail is proprietary to MphasiS and/ or its Customers and is inte= nded for use only by the individual or entity to which it is addressed, and may contain inform= ation that is privileged, confidential or exempt from disclosure under applicable law. If = you are not the intended recipient or it appears that this mail has been forwarded to you wi= thout proper authority, you are notified that any use or dissemination of this informatio= n in any manner is strictly prohibited. In such cases, please notify us immediately at mailm= aster@mphasis.com and delete this e-mail from your records.

 

--_NextPart_1_qmZrHLajoetbkwlTZTViemHPfyb--