Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 202D89FBA52 for ; Wed, 21 Mar 2007 23:49:11 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 08908-01 for ; Wed, 21 Mar 2007 23:49:01 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from weatherbeeta.com.au (218-214-212-153.people.net.au [218.214.212.153]) by postgresql.org (Postfix) with SMTP id 18CE49FB49E for ; Wed, 21 Mar 2007 23:49:05 -0300 (ADT) Received: (qmail 25377 invoked from network); 22 Mar 2007 02:49:04 -0000 X-NetworkBox-HamSign: 0101;OUT;wbeetaau1;984f08124420ee9c6f1e5458a51124a4; Received: from mail.weatherbeeta.com.au (10.10.0.2) by network-box.weatherbeeta.com.au with SMTP; 22 Mar 2007 02:49:03 -0000 Received: (qmail 29581 invoked by uid 1166); 22 Mar 2007 13:49:02 +1100 Received: from 172.20.1.145 by mail.weatherbeeta.com.au (envelope-from , uid 1165) with qmail-scanner-1.25-st-qms (clamdscan: 0.88.6/2315. perlscan: 1.25-st-qms. Clear:RC:1(172.20.1.145):. Processed in 0.502473 secs); 22 Mar 2007 02:49:02 -0000 X-Antivirus-mail.weatherbeeta.com.au-Mail-From: phillip.smith@weatherbeeta.com.au via mail.weatherbeeta.com.au X-Antivirus-mail.weatherbeeta.com.au: 1.25-st-qms (Clear:RC:1(172.20.1.145):. Processed in 0.502473 secs Process 29537) Received: from unknown (HELO ?172.20.1.145?) (phillip.smith@weatherbeeta.com.au@172.20.1.145) by mail.weatherbeeta.com.au with SMTP; 22 Mar 2007 13:48:58 +1100 Subject: Re: Vacuum taking forever From: Phillip Smith To: "Davidson, Robert" Cc: pgsql-admin@postgresql.org In-Reply-To: <8333C841129E074E9F83FC80676BA76E06191083@exchg-sea3-03.ant.amazon.com> References: <8333C841129E074E9F83FC80676BA76E06191083@exchg-sea3-03.ant.amazon.com> Content-Type: multipart/signed; micalg=sha1; protocol="application/x-pkcs7-signature"; boundary="=-Qe4VUgrXiE0hH2oPYiUE" Organization: Weatherbeeta P/L Date: Thu, 22 Mar 2007 13:48:53 +1100 Message-Id: <1174531733.5365.29.camel@it-laptop> Mime-Version: 1.0 X-Mailer: Evolution 2.8.1 X-Scanned-By-wbeetaau1: Virus scan performed by network-box X-Scanned-By-wbeetaau1: Scanner file id is wbeetaau1-1174531743.714-25365-000 X-Scanned-By-wbeetaau1: No known viruses found in message (received+scanned in 0.05/0.21 secs) X-Scanned-By-wbeetaau1: Spam-Check-Result: No, hits=0 required=7 tests= autolearn=no version=2.0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/158 X-Sequence-Number: 24982 --=-Qe4VUgrXiE0hH2oPYiUE Content-Type: multipart/alternative; boundary="=-PHUXyo+pwum029uYUpTv" --=-PHUXyo+pwum029uYUpTv Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable What are the specs of your machine? What is the memory settings in your postgresql.conf file? Cheers ~p On Wed, 2007-03-21 at 19:42 -0700, Davidson, Robert wrote: > df =E2=80=93h reports 806 MB free and 79 GB used. Is this enough free spa= ce to > perform a vacuum? Should I export the table, drop it, and re-import > it? --=-PHUXyo+pwum029uYUpTv Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable What are the specs of your machine? What is the memory settings in your pos= tgresql.conf file?

Cheers
~p

On Wed, 2007-03-21 at 19:42 -0700, Davidson, Robert wrote:
df –h reports 806 MB fre= e and 79 GB used. Is this enough free space to perform a vacuum? Should I e= xport the table, drop it, and re-import it?
--=-PHUXyo+pwum029uYUpTv-- --=-Qe4VUgrXiE0hH2oPYiUE Content-Type: application/x-pkcs7-signature; name=smime.p7s Content-Disposition: attachment; filename=smime.p7s Content-Transfer-Encoding: base64 MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIGQzCCAvww ggJloAMCAQICECgGLzg4fvuywaSUPjOvpbowDQYJKoZIhvcNAQEFBQAwYjELMAkGA1UEBhMCWkEx JTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQ ZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBMB4XDTA3MDIwNzA1MTc0M1oXDTA4MDIwNzA1MTc0 M1owUzEfMB0GA1UEAxMWVGhhd3RlIEZyZWVtYWlsIE1lbWJlcjEwMC4GCSqGSIb3DQEJARYhcGhp bGxpcC5zbWl0aEB3ZWF0aGVyYmVldGEuY29tLmF1MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIB CgKCAQEA0g7kg7BnVTuTt66o+M4w+YJ2sAt6abjbBLngvHoEx79/wrvCTMK0SlVdpR1P+qxM+Qpd Hnzi2iMvBbHJjJIgFndQtpF31RIlj1+/MSB7B4yzRwDIgiljPwVYUfJ8s2/M2++/wcCOi74OpSNF Um0HwZ8bPUohFpHeo3rjGjH4Ma3jOs2TH7jVI808T8bU24JleARbMpm8rCTcK2j0PTxYGCjvN15J FAOTr93yOJS0nMZbC7XCABPCxxpfWUi4x39Gx7dOKc/SskT1P+HHpDS41hSJ6C1fgnHgrjiUWF61 wkG+5pPRTsesxYDoIDsCOthz1VY2u7ncfg6itOLD41HrTQIDAQABoz4wPDAsBgNVHREEJTAjgSFw aGlsbGlwLnNtaXRoQHdlYXRoZXJiZWV0YS5jb20uYXUwDAYDVR0TAQH/BAIwADANBgkqhkiG9w0B AQUFAAOBgQACDFff/JMrNXly4WjbURYqld66NXpVnF6EMR/32JlA5eh/hiA49EKKbrkUgFETxfPD QasscsNEkBjcXoibq+Fk6JZNG3mA5Rct2aks3gP9fupVtcBJETXpLqlJ3CZsiX+fnFw/HgZtKRNV vam0kvXdHBY+WfYMQTTugskfCHVaqjCCAz8wggKooAMCAQICAQ0wDQYJKoZIhvcNAQEFBQAwgdEx CzAJBgNVBAYTAlpBMRUwEwYDVQQIEwxXZXN0ZXJuIENhcGUxEjAQBgNVBAcTCUNhcGUgVG93bjEa MBgGA1UEChMRVGhhd3RlIENvbnN1bHRpbmcxKDAmBgNVBAsTH0NlcnRpZmljYXRpb24gU2Vydmlj ZXMgRGl2aXNpb24xJDAiBgNVBAMTG1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBDQTErMCkGCSqG SIb3DQEJARYccGVyc29uYWwtZnJlZW1haWxAdGhhd3RlLmNvbTAeFw0wMzA3MTcwMDAwMDBaFw0x MzA3MTYyMzU5NTlaMGIxCzAJBgNVBAYTAlpBMSUwIwYDVQQKExxUaGF3dGUgQ29uc3VsdGluZyAo UHR5KSBMdGQuMSwwKgYDVQQDEyNUaGF3dGUgUGVyc29uYWwgRnJlZW1haWwgSXNzdWluZyBDQTCB nzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEAxKY8VXNV+065yplaHmjAdQRwnd/p/6Me7L3N9Vvy Gna9fww6YfK/Uc4B1OVQCjDXAmNaLIkVcI7dyfArhVqqP3FWy688Cwfn8R+RNiQqE88r1fOCdz0D viv+uxg+B79AgAJk16emu59l0cUqVIUPSAR/p7bRPGEEQB5kGXJgt/sCAwEAAaOBlDCBkTASBgNV HRMBAf8ECDAGAQH/AgEAMEMGA1UdHwQ8MDowOKA2oDSGMmh0dHA6Ly9jcmwudGhhd3RlLmNvbS9U aGF3dGVQZXJzb25hbEZyZWVtYWlsQ0EuY3JsMAsGA1UdDwQEAwIBBjApBgNVHREEIjAgpB4wHDEa MBgGA1UEAxMRUHJpdmF0ZUxhYmVsMi0xMzgwDQYJKoZIhvcNAQEFBQADgYEASIzRUIPqCy7MDaNm rGcPf6+svsIXoUOWlJ1/TCG4+DYfqi2fNi/A9BxQIJNwPP2t4WFiw9k6GX6EsZkbAMUaC4J0niVQ lGLH2ydxVyWN3amcOY6MIE9lX5Xa9/eH1sYITq726jTlEBpbNU1341YheILcIRk13iSx0x1G/11f ZU8xggH8MIIB+AIBATB2MGIxCzAJBgNVBAYTAlpBMSUwIwYDVQQKExxUaGF3dGUgQ29uc3VsdGlu ZyAoUHR5KSBMdGQuMSwwKgYDVQQDEyNUaGF3dGUgUGVyc29uYWwgRnJlZW1haWwgSXNzdWluZyBD QQIQKAYvODh++7LBpJQ+M6+lujAJBgUrDgMCGgUAoF0wGAYJKoZIhvcNAQkDMQsGCSqGSIb3DQEH ATAcBgkqhkiG9w0BCQUxDxcNMDcwMzIyMDI0ODUzWjAjBgkqhkiG9w0BCQQxFgQUIvh17P+xihQO AergyZMeK5qIuT0wDQYJKoZIhvcNAQEBBQAEggEAKCdo6ed0dBQL1i3U61OvnUUCWzFtsEwdN9hR 0aFxkYzuVuvVQrth8YVYADGjsDSeamycaWZUs7wN1vnvCvgkoV5U5SRXpVZPknNb+LRORYVu+Tbz Dd/T6E6mZMx4UCfKW7dYi3yUByDamylX3f76FyAmC4riMWXX6k67hOGqIPqSP7ZOhH9WRE6d9AuP bRxe63/TXLSOOmnkmybsuPJLZlNpxYS/hKdJ67VYRJK1bPc4ZUtYSy3No5POyNcAMW88xENHV2X2 nW8DOD0yvQHSqzkMwrL1GHhy+Kvtvqs84y/UdAl/AEM51Uie7L9nhTbvMHCha2ELyps7Ui1fqCcC wQAAAAAAAA== --=-Qe4VUgrXiE0hH2oPYiUE--