X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 1E80F52934 for ; Thu, 23 Jun 2005 10:46:40 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 44747-06 for ; Thu, 23 Jun 2005 13:46:35 +0000 (GMT) Received: from www.aldratech.com (www.aldratech.com [193.226.161.42]) by svr1.postgresql.org (Postfix) with ESMTP id D415652899 for ; Thu, 23 Jun 2005 10:46:34 -0300 (ADT) Received: from [192.168.0.6] (rpopescu [192.168.0.6]) by www.aldratech.com (Postfix) with ESMTP id 86A56123D84 for ; Thu, 23 Jun 2005 16:44:50 +0300 (EEST) Message-ID: <42BABD37.9030207@aldratech.com> Date: Thu, 23 Jun 2005 16:46:31 +0300 From: Radu-Adrian Popescu Reply-To: radu.popescu@aldratech.com Organization: Aldratech Ltd. User-Agent: Mozilla Thunderbird 1.0 (X11/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: Performance Tuning Article References: <20050622095227.05938982.frank@wiles.org> <200506221016.03808.josh@agliodbs.com> <20050622124232.71b05e3f.frank@wiles.org> <42BA1F01.1010700@NarrowPathInc.com> <42BA7F49.6080101@aldratech.com> <42BAA816.2040806@NarrowPathInc.com> <533D107C-FDF0-4A6A-A88F-0751DCDDEA4D@fastcrypt.com> In-Reply-To: <533D107C-FDF0-4A6A-A88F-0751DCDDEA4D@fastcrypt.com> Content-Type: multipart/signed; protocol="application/x-pkcs7-signature"; micalg=sha1; boundary="------------ms010800030707020304050607" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200506/452 X-Sequence-Number: 13089 This is a cryptographically signed message in MIME format. --------------ms010800030707020304050607 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Dave Cramer wrote: > My understanding is that it isn't particularly XEON processors that is > the problem > > Any dual processor will exhibit the problem, XEON's with hyperthreading > exacerbate the problem though > > and the good news is that it has been fixed in 8.1 > Where's that ? The only information I have is a message from Tom Lane saying the buffer manager (or something like that) locking has been redone for 8.0. Any pointers ? > Dave Thanks, -- Radu-Adrian Popescu CSA, DBA, Developer Aldrapay MD Aldratech Ltd. +40213212243 --------------ms010800030707020304050607 Content-Type: application/x-pkcs7-signature; name="smime.p7s" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="smime.p7s" Content-Description: S/MIME Cryptographic Signature MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIJDTCC AuEwggJKoAMCAQICAw0/VDANBgkqhkiG9w0BAQQFADBiMQswCQYDVQQGEwJaQTElMCMGA1UE ChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNv bmFsIEZyZWVtYWlsIElzc3VpbmcgQ0EwHhcNMDQxMDE4MTEwNjM0WhcNMDUxMDE4MTEwNjM0 WjBMMR8wHQYDVQQDExZUaGF3dGUgRnJlZW1haWwgTWVtYmVyMSkwJwYJKoZIhvcNAQkBFhpy YWR1LnBvcGVzY3VAYWxkcmF0ZWNoLmNvbTCCASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoC ggEBAM+UjztouTxkdmm0OFNJxUGs2UpnbgswyyR0EmZYGpPnge2EjGIbnxgCsgtId466dmqw OokdKo7xf/XNzhYxR3NluUf6SsQhd8lVWt8ATHFchGEs5iHZAEcsbu2hzkrVTbrgfcer8+r/ WUlrEiMC1tJBXKQFxqVDZiLDrfGs+yxm0HSwnHE9DFrNFUpcqvZ0haBs4DA52AQw6rOxZaza eoDVXETwOHKp5K4igmC7Fu1tyA63g7RMn7dDtZ9r6U86FfN6RAOJ0SVvvlRWq31Z8ziLNtKO EytsMpVPlVL1Hhx86S5gqweU9YaXsZ3jfHXkMo8tpN33hplgBtPcjwToLnUCAwEAAaM3MDUw JQYDVR0RBB4wHIEacmFkdS5wb3Blc2N1QGFsZHJhdGVjaC5jb20wDAYDVR0TAQH/BAIwADAN BgkqhkiG9w0BAQQFAAOBgQBq9KdN3dCGQ2TgIrAjyWeDihQMsVMdfAVymKpOz/SDwsvnVP0N 9PDFr3MAcKql/ZodgVm4GylYyQVALIT6UcsjBd38kRRaLZhwB4zyp1s22uYsc3e7cnMgFs2F 2210Tv0WMMeRbRiMK6JCskLFxNg6N7w072+z/IOxcFpH3ZPBPzCCAuEwggJKoAMCAQICAw0/ VDANBgkqhkiG9w0BAQQFADBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1 bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIElz c3VpbmcgQ0EwHhcNMDQxMDE4MTEwNjM0WhcNMDUxMDE4MTEwNjM0WjBMMR8wHQYDVQQDExZU aGF3dGUgRnJlZW1haWwgTWVtYmVyMSkwJwYJKoZIhvcNAQkBFhpyYWR1LnBvcGVzY3VAYWxk cmF0ZWNoLmNvbTCCASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEBAM+UjztouTxkdmm0 OFNJxUGs2UpnbgswyyR0EmZYGpPnge2EjGIbnxgCsgtId466dmqwOokdKo7xf/XNzhYxR3Nl uUf6SsQhd8lVWt8ATHFchGEs5iHZAEcsbu2hzkrVTbrgfcer8+r/WUlrEiMC1tJBXKQFxqVD ZiLDrfGs+yxm0HSwnHE9DFrNFUpcqvZ0haBs4DA52AQw6rOxZazaeoDVXETwOHKp5K4igmC7 Fu1tyA63g7RMn7dDtZ9r6U86FfN6RAOJ0SVvvlRWq31Z8ziLNtKOEytsMpVPlVL1Hhx86S5g qweU9YaXsZ3jfHXkMo8tpN33hplgBtPcjwToLnUCAwEAAaM3MDUwJQYDVR0RBB4wHIEacmFk dS5wb3Blc2N1QGFsZHJhdGVjaC5jb20wDAYDVR0TAQH/BAIwADANBgkqhkiG9w0BAQQFAAOB gQBq9KdN3dCGQ2TgIrAjyWeDihQMsVMdfAVymKpOz/SDwsvnVP0N9PDFr3MAcKql/ZodgVm4 GylYyQVALIT6UcsjBd38kRRaLZhwB4zyp1s22uYsc3e7cnMgFs2F2210Tv0WMMeRbRiMK6JC skLFxNg6N7w072+z/IOxcFpH3ZPBPzCCAz8wggKooAMCAQICAQ0wDQYJKoZIhvcNAQEFBQAw gdExCzAJBgNVBAYTAlpBMRUwEwYDVQQIEwxXZXN0ZXJuIENhcGUxEjAQBgNVBAcTCUNhcGUg VG93bjEaMBgGA1UEChMRVGhhd3RlIENvbnN1bHRpbmcxKDAmBgNVBAsTH0NlcnRpZmljYXRp b24gU2VydmljZXMgRGl2aXNpb24xJDAiBgNVBAMTG1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFp bCBDQTErMCkGCSqGSIb3DQEJARYccGVyc29uYWwtZnJlZW1haWxAdGhhd3RlLmNvbTAeFw0w MzA3MTcwMDAwMDBaFw0xMzA3MTYyMzU5NTlaMGIxCzAJBgNVBAYTAlpBMSUwIwYDVQQKExxU aGF3dGUgQ29uc3VsdGluZyAoUHR5KSBMdGQuMSwwKgYDVQQDEyNUaGF3dGUgUGVyc29uYWwg RnJlZW1haWwgSXNzdWluZyBDQTCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEAxKY8VXNV +065yplaHmjAdQRwnd/p/6Me7L3N9VvyGna9fww6YfK/Uc4B1OVQCjDXAmNaLIkVcI7dyfAr hVqqP3FWy688Cwfn8R+RNiQqE88r1fOCdz0Dviv+uxg+B79AgAJk16emu59l0cUqVIUPSAR/ p7bRPGEEQB5kGXJgt/sCAwEAAaOBlDCBkTASBgNVHRMBAf8ECDAGAQH/AgEAMEMGA1UdHwQ8 MDowOKA2oDSGMmh0dHA6Ly9jcmwudGhhd3RlLmNvbS9UaGF3dGVQZXJzb25hbEZyZWVtYWls Q0EuY3JsMAsGA1UdDwQEAwIBBjApBgNVHREEIjAgpB4wHDEaMBgGA1UEAxMRUHJpdmF0ZUxh YmVsMi0xMzgwDQYJKoZIhvcNAQEFBQADgYEASIzRUIPqCy7MDaNmrGcPf6+svsIXoUOWlJ1/ TCG4+DYfqi2fNi/A9BxQIJNwPP2t4WFiw9k6GX6EsZkbAMUaC4J0niVQlGLH2ydxVyWN3amc OY6MIE9lX5Xa9/eH1sYITq726jTlEBpbNU1341YheILcIRk13iSx0x1G/11fZU8xggM7MIID NwIBATBpMGIxCzAJBgNVBAYTAlpBMSUwIwYDVQQKExxUaGF3dGUgQ29uc3VsdGluZyAoUHR5 KSBMdGQuMSwwKgYDVQQDEyNUaGF3dGUgUGVyc29uYWwgRnJlZW1haWwgSXNzdWluZyBDQQID DT9UMAkGBSsOAwIaBQCgggGnMBgGCSqGSIb3DQEJAzELBgkqhkiG9w0BBwEwHAYJKoZIhvcN AQkFMQ8XDTA1MDYyMzEzNDYzMVowIwYJKoZIhvcNAQkEMRYEFB/+pezIjlJZ6M6ru+vuJGrP 6ZbtMFIGCSqGSIb3DQEJDzFFMEMwCgYIKoZIhvcNAwcwDgYIKoZIhvcNAwICAgCAMA0GCCqG SIb3DQMCAgFAMAcGBSsOAwIHMA0GCCqGSIb3DQMCAgEoMHgGCSsGAQQBgjcQBDFrMGkwYjEL MAkGA1UEBhMCWkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAq BgNVBAMTI1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBAgMNP1QwegYLKoZI hvcNAQkQAgsxa6BpMGIxCzAJBgNVBAYTAlpBMSUwIwYDVQQKExxUaGF3dGUgQ29uc3VsdGlu ZyAoUHR5KSBMdGQuMSwwKgYDVQQDEyNUaGF3dGUgUGVyc29uYWwgRnJlZW1haWwgSXNzdWlu ZyBDQQIDDT9UMA0GCSqGSIb3DQEBAQUABIIBAIKhvSmmckFw1U+JNTISU+51rYkVlnT9GFvV eu4JOylbigKE1afVZsXLehr7T6tRZQdFHoCjfSPL4AMu7foi7uWt0yMiFJLToDLb5SAD6MCz bs8c7QiE2HJ3xeVmHsZ9df3i8mMLzzuclHc+FqnIh6fRkyDODUIqO/C/u5GxGXiALiDC8Jch l/lzt8crfgXt/B4FsOVqny+KzBg1aKE0VCIl71MCN6cp2GqYfZgMzjt4WMslYgBxkvAoLAr+ BPnzof/CoC+fgKnnmmkStN1Ph6BaSr4WAcYvtI8PcS1esD4m5a+r1D+8dcXDNRO5goxuUboo rNPidPfDsUCXZIm7N04AAAAAAAA= --------------ms010800030707020304050607--