Received: from maia.hub.org (maia-4.hub.org [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id B108263378D for ; Tue, 25 May 2010 11:04:24 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 41454-05 for ; Tue, 25 May 2010 14:04:15 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from tutopia.com (mail04mass.ifxnetworks.com [190.60.24.74]) by mail.postgresql.org (Postfix) with ESMTP id 457ED6321D3 for ; Tue, 25 May 2010 11:04:15 -0300 (ADT) Received: (qmail 32549 invoked from network); 25 May 2010 14:04:13 -0000 Received: from unknown (HELO mail13.ifxnetworks.com) ([190.61.128.23]) (envelope-sender ) by mail04mass.ifxnetworks.com (qmail-ldap-1.03) with SMTP for ; 25 May 2010 14:04:07 -0000 Content-Transfer-Encoding: 7bit Content-Type: multipart/mixed; boundary="_----------=_1274796247269340" MIME-Version: 1.0 From: Juan Pablo Sandoval Rivera To: pgsql-performance@postgresql.org Subject: tunning pgsql 7.3.7 over RHEL 4.0 32 x86 (2.6.9-5ELsmp) Reply-To: juapabsan@tutopia.com X-Origin: 190.60.24.4 Date: Tue, 25 May 2010 14:04:07 +0000 X-Uidl: 1274796247269344348 X-Mailer: MIME::Lite 3.01 (F2.74; T1.21; A1.52; B3.07; Q3.07) Message-Id: <20100525140415.457ED6321D3@mail.postgresql.org> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.001 tagged_above=-10 required=5 tests=BAYES_40=-0.001 X-Spam-Level: X-Archive-Number: 201005/177 X-Sequence-Number: 38761 This is a multi-part message in MIME format. --_----------=_1274796247269340 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset="iso-8859-1" Good day list =0D =0D I would appreciate some comments to the following: =0D =0D I have a Dell PowerEdge SC1420 server with 2 GB of RAM 1 DD 73 Gb SCSI Ullt= ra320 2 Xeon (4 =0D cache) with PGSQL 7.3.7 =0D =0D running GNU / Linux Red Hat Enterprise 4, 0 for 32-bit (kernel 2.6.9-5Elsmp= ) Nahant (ES) =0D =0D and another server start or operate the same system and database engine, HP= Proliant ML 150 G6 =0D two Smart Array P410 Xeon 2 GB RAM, 2 DD Sata 15,000 RPM (250 GB) in RAID 1= =0D =0D =0D =0D I'm validating the operation and Execution / time difference of a process b= etween the two is =0D not really maquians muicha few seconds almost no time to think it is just q= uicker the Dell =0D machine, it must obviously affect the technology of hard drives. =0D =0D shmmax is set to 500.00.000, annex Execution / parameters of both machines = pg_settings =0D consultation. =0D =0D Please let me give recommendation to the confituracion, if this correct or = would fail or left =0D over tune. an average of 30 users use the system, and is heavy disk usage, = uan table has 8 =0D million + another + 13 milloines, the 8 is used daily, desarfortunadame Pro= gress can not yet =0D migrate to 8.x, that tiempoi tiomaria a development, adjustment and testing= , but it will fit =0D with the current configuration that I mentioned. =0D =0D Thank you.=0D =0D =0D Juan Pablo Sandoval Rivera=0D Tecnologo Prof. en Ing. de Sistemas=0D =0D Linux User : 322765 =0D msn : juan_pablos@hotmail.com=0D yahoo : juan_pablos@rocketmail.com (juan_pablos.rm)=0D UIN : 276125187 (ICQ)=0D Jabber : juan_pablos@www.jabberES.org=0D Skype : juan.pablo.sandoval.rivera=0D =0D APOYA A ECOSEARCH.COM - Ayuda a salvar al Planeta.=0D =0D =0D =0D --_----------=_1274796247269340 Content-Disposition: inline; filename="80173-settings7.3.7dell" Content-Transfer-Encoding: base64 Content-Type: application/octet-stream; name="80173-settings7.3.7dell" YXVzdHJhbGlhbl90aW1lem9uZXMJb2ZmCmF1dGhlbnRpY2F0aW9uX3RpbWVv dXQJNjAKYXV0b2NvbW1pdAlvbgpjaGVja3BvaW50X3NlZ21lbnRzCTMKY2hl Y2twb2ludF90aW1lb3V0CTMwMApjbGllbnRfZW5jb2RpbmcJU1FMX0FTQ0lJ CmNsaWVudF9taW5fbWVzc2FnZXMJbm90aWNlCmNvbW1pdF9kZWxheQkwCmNv bW1pdF9zaWJsaW5ncwk1CmNwdV9pbmRleF90dXBsZV9jb3N0CTAuMDAxCmNw dV9vcGVyYXRvcl9jb3N0CTAuMDAyNQpjcHVfdHVwbGVfY29zdAkwLjAxCkRh dGVTdHlsZQlJU08gd2l0aCBVUyAoTm9uRXVyb3BlYW4pIGNvbnZlbnRpb25z CmRiX3VzZXJfbmFtZXNwYWNlCW9mZgpkZWFkbG9ja190aW1lb3V0CTEwMDAK ZGVidWdfcHJldHR5X3ByaW50CW9mZgpkZWJ1Z19wcmludF9wYXJzZQlvZmYK ZGVidWdfcHJpbnRfcGxhbglvZmYKZGVidWdfcHJpbnRfcmV3cml0dGVuCW9m ZgpkZWZhdWx0X3N0YXRpc3RpY3NfdGFyZ2V0CTEwCmRlZmF1bHRfdHJhbnNh Y3Rpb25faXNvbGF0aW9uCXJlYWQgY29tbWl0dGVkCmR5bmFtaWNfbGlicmFy eV9wYXRoCSRsaWJkaXIKZWZmZWN0aXZlX2NhY2hlX3NpemUJMWUrMDcKZW5h YmxlX2hhc2hqb2luCW9uCmVuYWJsZV9pbmRleHNjYW4Jb24KZW5hYmxlX21l cmdlam9pbglvbgplbmFibGVfbmVzdGxvb3AJb24KZW5hYmxlX3NlcXNjYW4J b24KZW5hYmxlX3NvcnQJb24KZW5hYmxlX3RpZHNjYW4Jb24KZXhwbGFpbl9w cmV0dHlfcHJpbnQJb24KZml4YnRyZWUJb24KZnN5bmMJb24KZ2Vxbwlvbgpn ZXFvX2VmZm9ydAkxCmdlcW9fZ2VuZXJhdGlvbnMJMApnZXFvX3Bvb2xfc2l6 ZQkwCmdlcW9fcmFuZG9tX3NlZWQJLTEKZ2Vxb19zZWxlY3Rpb25fYmlhcwky CmdlcW9fdGhyZXNob2xkCTExCmhvc3RuYW1lX2xvb2t1cAlvZmYKa3JiX3Nl cnZlcl9rZXlmaWxlCXVuc2V0CmxjX21lc3NhZ2VzCWVzX0VTLlVURi04Cmxj X21vbmV0YXJ5CWVzX0VTLlVURi04CmxjX251bWVyaWMJZXNfRVMuVVRGLTgK bGNfdGltZQllc19FUy5VVEYtOApsb2dfY29ubmVjdGlvbnMJb24KbG9nX2R1 cmF0aW9uCW9mZgpsb2dfbWluX2Vycm9yX3N0YXRlbWVudAlwYW5pYwpsb2df cGlkCW9mZgpsb2dfc3RhdGVtZW50CW9uCmxvZ190aW1lc3RhbXAJb2ZmCm1h eF9jb25uZWN0aW9ucwkyNTYKbWF4X2V4cHJfZGVwdGgJMTAwMDAKbWF4X2Zp bGVzX3Blcl9wcm9jZXNzCTEwMDAKbWF4X2ZzbV9wYWdlcwkxMDAwMAptYXhf ZnNtX3JlbGF0aW9ucwkxMDAwCm1heF9sb2Nrc19wZXJfdHJhbnNhY3Rpb24J NjQKcGFzc3dvcmRfZW5jcnlwdGlvbglvbgpwb3J0CTU0MzIKcHJlX2F1dGhf ZGVsYXkJMApyYW5kb21fcGFnZV9jb3N0CTQKc2VhcmNoX3BhdGgJJHVzZXIs cHVibGljCnNlcnZlcl9lbmNvZGluZwlTUUxfQVNDSUkKc2VydmVyX21pbl9t ZXNzYWdlcwlkZWJ1ZzIKc2hhcmVkX2J1ZmZlcnMJNTQwMDAKc2hvd19leGVj dXRvcl9zdGF0cwlvZmYKc2hvd19wYXJzZXJfc3RhdHMJb2ZmCnNob3dfcGxh bm5lcl9zdGF0cwlvZmYKc2hvd19zb3VyY2VfcG9ydAlvZmYKc2hvd19zdGF0 ZW1lbnRfc3RhdHMJb2ZmCnNpbGVudF9tb2RlCW9mZgpzb3J0X21lbQkyNjIx NDQKc3FsX2luaGVyaXRhbmNlCW9uCnNzbAlvZmYKc3RhdGVtZW50X3RpbWVv dXQJMApzdGF0c19ibG9ja19sZXZlbAlvZmYKc3RhdHNfY29tbWFuZF9zdHJp bmcJb2ZmCnN0YXRzX3Jlc2V0X29uX3NlcnZlcl9zdGFydAlvbgpzdGF0c19y b3dfbGV2ZWwJb2ZmCnN0YXRzX3N0YXJ0X2NvbGxlY3RvcglvbgpzdXBlcnVz ZXJfcmVzZXJ2ZWRfY29ubmVjdGlvbnMJMgpzeXNsb2cJMApzeXNsb2dfZmFj aWxpdHkJTE9DQUwwCnN5c2xvZ19pZGVudAlwb3N0Z3Jlcwp0Y3BpcF9zb2Nr ZXQJb24KVGltZVpvbmUJdW5rbm93bgp0cmFjZV9ub3RpZnkJb2ZmClRSQU5T QUNUSU9OIElTT0xBVElPTiBMRVZFTAlSRUFEIENPTU1JVFRFRAp0cmFuc2Zv cm1fbnVsbF9lcXVhbHMJb2ZmCnVuaXhfc29ja2V0X2RpcmVjdG9yeQl1bnNl dAp1bml4X3NvY2tldF9ncm91cAl1bnNldAp1bml4X3NvY2tldF9wZXJtaXNz aW9ucwk1MTEKdmFjdXVtX21lbQk1MTIwMDAKdmlydHVhbF9ob3N0CXVuc2V0 CndhbF9idWZmZXJzCTMyCndhbF9kZWJ1ZwkwCndhbF9zeW5jX21ldGhvZAlm ZGF0YXN5bmMKemVyb19kYW1hZ2VkX3BhZ2VzCW9mZgo= --_----------=_1274796247269340 Content-Disposition: inline; filename="80173-settings_7.3.7hp" Content-Transfer-Encoding: base64 Content-Type: application/octet-stream; name="80173-settings_7.3.7hp" YXVzdHJhbGlhbl90aW1lem9uZXMJb2ZmCmF1dGhlbnRpY2F0aW9uX3RpbWVv dXQJNjAKYXV0b2NvbW1pdAlvbgpjaGVja3BvaW50X3NlZ21lbnRzCTY0CmNo ZWNrcG9pbnRfdGltZW91dAkzMDAKY2xpZW50X2VuY29kaW5nCVNRTF9BU0NJ SQpjbGllbnRfbWluX21lc3NhZ2VzCW5vdGljZQpjb21taXRfZGVsYXkJMApj b21taXRfc2libGluZ3MJNQpjcHVfaW5kZXhfdHVwbGVfY29zdAkwLjAwMQpj cHVfb3BlcmF0b3JfY29zdAkwLjAwMjUKY3B1X3R1cGxlX2Nvc3QJMC4wMQpE YXRlU3R5bGUJSVNPIHdpdGggVVMgKE5vbkV1cm9wZWFuKSBjb252ZW50aW9u cwpkYl91c2VyX25hbWVzcGFjZQlvZmYKZGVhZGxvY2tfdGltZW91dAkxMDAw CmRlYnVnX3ByZXR0eV9wcmludAlvZmYKZGVidWdfcHJpbnRfcGFyc2UJb2Zm CmRlYnVnX3ByaW50X3BsYW4Jb2ZmCmRlYnVnX3ByaW50X3Jld3JpdHRlbglv ZmYKZGVmYXVsdF9zdGF0aXN0aWNzX3RhcmdldAkxMApkZWZhdWx0X3RyYW5z YWN0aW9uX2lzb2xhdGlvbglyZWFkIGNvbW1pdHRlZApkeW5hbWljX2xpYnJh cnlfcGF0aAkkbGliZGlyCmVmZmVjdGl2ZV9jYWNoZV9zaXplCTFlKzA3CmVu YWJsZV9oYXNoam9pbglvbgplbmFibGVfaW5kZXhzY2FuCW9uCmVuYWJsZV9t ZXJnZWpvaW4Jb24KZW5hYmxlX25lc3Rsb29wCW9uCmVuYWJsZV9zZXFzY2Fu CW9uCmVuYWJsZV9zb3J0CW9uCmVuYWJsZV90aWRzY2FuCW9uCmV4cGxhaW5f cHJldHR5X3ByaW50CW9uCmZpeGJ0cmVlCW9uCmZzeW5jCW9uCmdlcW8Jb24K Z2Vxb19lZmZvcnQJMQpnZXFvX2dlbmVyYXRpb25zCTAKZ2Vxb19wb29sX3Np emUJMApnZXFvX3JhbmRvbV9zZWVkCS0xCmdlcW9fc2VsZWN0aW9uX2JpYXMJ MgpnZXFvX3RocmVzaG9sZAkxMQpob3N0bmFtZV9sb29rdXAJb2ZmCmtyYl9z ZXJ2ZXJfa2V5ZmlsZQl1bnNldApsY19tZXNzYWdlcwllbl9VUy5VVEYtOAps Y19tb25ldGFyeQllbl9VUy5VVEYtOApsY19udW1lcmljCWVuX1VTLlVURi04 CmxjX3RpbWUJZW5fVVMuVVRGLTgKbG9nX2Nvbm5lY3Rpb25zCW9uCmxvZ19k dXJhdGlvbglvZmYKbG9nX21pbl9lcnJvcl9zdGF0ZW1lbnQJcGFuaWMKbG9n X3BpZAlvZmYKbG9nX3N0YXRlbWVudAlvbgpsb2dfdGltZXN0YW1wCW9mZgpt YXhfY29ubmVjdGlvbnMJMjU2Cm1heF9leHByX2RlcHRoCTEwMDAwCm1heF9m aWxlc19wZXJfcHJvY2VzcwkxMDAwCm1heF9mc21fcGFnZXMJMjAwMDAwCm1h eF9mc21fcmVsYXRpb25zCTE1MDAKbWF4X2xvY2tzX3Blcl90cmFuc2FjdGlv bgk2NApwYXNzd29yZF9lbmNyeXB0aW9uCW9uCnBvcnQJNTQzMgpwcmVfYXV0 aF9kZWxheQkwCnJhbmRvbV9wYWdlX2Nvc3QJMS41CnNlYXJjaF9wYXRoCSR1 c2VyLHB1YmxpYwpzZXJ2ZXJfZW5jb2RpbmcJU1FMX0FTQ0lJCnNlcnZlcl9t aW5fbWVzc2FnZXMJZGVidWcyCnNoYXJlZF9idWZmZXJzCTU0MDAwCnNob3df ZXhlY3V0b3Jfc3RhdHMJb2ZmCnNob3dfcGFyc2VyX3N0YXRzCW9mZgpzaG93 X3BsYW5uZXJfc3RhdHMJb2ZmCnNob3dfc291cmNlX3BvcnQJb2ZmCnNob3df c3RhdGVtZW50X3N0YXRzCW9mZgpzaWxlbnRfbW9kZQlvZmYKc29ydF9tZW0J MTAyNApzcWxfaW5oZXJpdGFuY2UJb24Kc3NsCW9mZgpzdGF0ZW1lbnRfdGlt ZW91dAkwCnN0YXRzX2Jsb2NrX2xldmVsCW9mZgpzdGF0c19jb21tYW5kX3N0 cmluZwlvZmYKc3RhdHNfcmVzZXRfb25fc2VydmVyX3N0YXJ0CW9uCnN0YXRz X3Jvd19sZXZlbAlvZmYKc3RhdHNfc3RhcnRfY29sbGVjdG9yCW9uCnN1cGVy dXNlcl9yZXNlcnZlZF9jb25uZWN0aW9ucwkyCnN5c2xvZwkwCnN5c2xvZ19m YWNpbGl0eQlMT0NBTDAKc3lzbG9nX2lkZW50CXBvc3RncmVzCnRjcGlwX3Nv Y2tldAlvbgpUaW1lWm9uZQl1bmtub3duCnRyYWNlX25vdGlmeQlvZmYKVFJB TlNBQ1RJT04gSVNPTEFUSU9OIExFVkVMCVJFQUQgQ09NTUlUVEVECnRyYW5z Zm9ybV9udWxsX2VxdWFscwlvZmYKdW5peF9zb2NrZXRfZGlyZWN0b3J5CXVu c2V0CnVuaXhfc29ja2V0X2dyb3VwCXVuc2V0CnVuaXhfc29ja2V0X3Blcm1p c3Npb25zCTUxMQp2YWN1dW1fbWVtCTgxOTIKdmlydHVhbF9ob3N0CXVuc2V0 CndhbF9idWZmZXJzCTY0CndhbF9kZWJ1ZwkwCndhbF9zeW5jX21ldGhvZAlm ZGF0YXN5bmMKemVyb19kYW1hZ2VkX3BhZ2VzCW9mZgo= --_----------=_1274796247269340--