Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id DFC099FB2C4 for ; Tue, 16 Oct 2007 12:00:58 -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 98109-01 for ; Tue, 16 Oct 2007 12:00:53 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.174]) by postgresql.org (Postfix) with ESMTP id 45CD39FA52A for ; Tue, 16 Oct 2007 12:00:52 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id j3so92011ugf for ; Tue, 16 Oct 2007 08:00:51 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type; bh=M7aVxOCvZ6m5GrnUvVJIpybFvgqBAl/VRL5JKdoEJbY=; b=SePg8ZFipSW1SKdsS0bj3mfA8Q07h6KUAR9GdUl3wbkjHjEMnCEx0YZY0NJ2IDe1xrjvAjMVQ4WPoRwaORtU0YNw5B3j/Y4u4bB4ArSUIiaFizI7fgbTwfN5uxKfE9FoVXzW1G36f5PySF7hZHd3WtOMEzbt0F+j6t9K1oEA/8E= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type; b=M1PHkNGV116fAedaLxPNqMVnKHROpwHdc9zVGf07Yu5AYXcPWjU4E3ZuLop6QkFY1mipqbHoGZJo5kjPHKk2HdXt6PnUJf0aGxIS+EFIVWEmh3Ud/FtB9EFfRSV9T9nBl0Tt5r7+2gWAtUrSBRQtzvBlnN/hfy9CLDMiH8+dIOs= Received: by 10.142.73.8 with SMTP id v8mr2075544wfa.1192546849321; Tue, 16 Oct 2007 08:00:49 -0700 (PDT) Received: from ?190.18.168.121? ( [190.18.168.121]) by mx.google.com with ESMTPS id 62sm4507055wri.2007.10.16.08.00.46 (version=TLSv1/SSLv3 cipher=RC4-MD5); Tue, 16 Oct 2007 08:00:48 -0700 (PDT) Message-ID: <4714D214.3010902@gmail.com> Date: Tue, 16 Oct 2007 12:00:36 -0300 From: Rodrigo Gonzalez User-Agent: Thunderbird 2.0.0.6 (Windows/20070728) MIME-Version: 1.0 To: Jason Lustig CC: Richard Huxton , pgsql-performance@postgresql.org Subject: Re: Autovacuum running out of memory References: <374EB3D1-EE74-4B8C-9EEC-104ADD097568@brandeis.edu> <4714A458.5060408@archonet.com> <4714AD30.6000103@archonet.com> <57031F92-40D5-4832-8B76-FB73E510C735@brandeis.edu> <4714C426.3080207@archonet.com> <4714C92B.6010909@archonet.com> <867529B2-4584-4A1C-AE58-6BA8A12EEFC3@brandeis.edu> In-Reply-To: <867529B2-4584-4A1C-AE58-6BA8A12EEFC3@brandeis.edu> Content-Type: multipart/signed; protocol="application/x-pkcs7-signature"; micalg=sha1; boundary="------------ms090802080403060506090701" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/182 X-Sequence-Number: 27204 This is a cryptographically signed message in MIME format. --------------ms090802080403060506090701 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Jason Lustig escribi=F3: > On Oct 16, 2007, at 10:22 AM, Richard Huxton wrote: > >> Add some lines to /etc/security/limits.conf to increase them. > > Sorry for being somewhat of a linux novice -- but what is the best way = > to do this? It doesn't seem to provide matching options from ulimit to = > the limits.conf file. > > Thanks, > Jason > > ---------------------------(end of broadcast)--------------------------= - > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your= > message can get through to the mailing list cleanly > http://www.userlocal.com/security/secpam.php --------------ms090802080403060506090701 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 MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIJCzCC AuAwggJJoAMCAQICEFKu3/n0oTKNim1sXE5AIgswDQYJKoZIhvcNAQEFBQAwYjELMAkGA1UE BhMCWkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMT I1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBMB4XDTA3MDkwNTEyMzIyNFoX DTA4MDkwNDEyMzIyNFowRTEfMB0GA1UEAxMWVGhhd3RlIEZyZWVtYWlsIE1lbWJlcjEiMCAG CSqGSIb3DQEJARYTcmpnb256YWxlQGdtYWlsLmNvbTCCASIwDQYJKoZIhvcNAQEBBQADggEP ADCCAQoCggEBALjktG7EMWR5pPz82DfSue+kNXszsWfpEWrRtFt0jBM01Pz6tiYVTy1IMgxl R03UOuGdOkyqK9TkLxCbN80I0xBbM/1r4Z35FJ/EN+Vm/DPBGOwuxJEw4Dj8/5uDrPkRVC0b j+YRxZsM4TOJjIrrqO/6xPRe4pns+gYvHdcW98mR2hyeTIBnx7WcQfPUMOzmPUt/nJNakxgH A1B2724RMeGQpMh8pHUJ7B04RNt+f3sLzr9c+a815AhdNqPPMjmcnkRtjcdCK3K+dngtQzp4 TbiUnUBQtjCvF31EK75NcbRJdGZhJCRjsjJtW5Nep9TJ7tBrTHUxNEDt11cDJnLe4i8CAwEA AaMwMC4wHgYDVR0RBBcwFYETcmpnb256YWxlQGdtYWlsLmNvbTAMBgNVHRMBAf8EAjAAMA0G CSqGSIb3DQEBBQUAA4GBAKX5592Z5SwMOtNc99oEJGEPwk8K2/z/0G8VSkJoWR1rYxWvBF7+ biHZ4T7sQBUw0FUgyWV+swc/DtTDZDr+J2WWKIcMFMRHX+Fmo7SyqPWL1+jhmSolbWoq6eHj U2YOxPDJflcl8okL5b85y4m9lsCHS0qtIZ1KJ5oFod1zFOxlMIIC4DCCAkmgAwIBAgIQUq7f +fShMo2KbWxcTkAiCzANBgkqhkiG9w0BAQUFADBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMc VGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFs IEZyZWVtYWlsIElzc3VpbmcgQ0EwHhcNMDcwOTA1MTIzMjI0WhcNMDgwOTA0MTIzMjI0WjBF MR8wHQYDVQQDExZUaGF3dGUgRnJlZW1haWwgTWVtYmVyMSIwIAYJKoZIhvcNAQkBFhNyamdv bnphbGVAZ21haWwuY29tMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAuOS0bsQx ZHmk/PzYN9K576Q1ezOxZ+kRatG0W3SMEzTU/Pq2JhVPLUgyDGVHTdQ64Z06TKor1OQvEJs3 zQjTEFsz/WvhnfkUn8Q35Wb8M8EY7C7EkTDgOPz/m4Os+RFULRuP5hHFmwzhM4mMiuuo7/rE 9F7imez6Bi8d1xb3yZHaHJ5MgGfHtZxB89Qw7OY9S3+ck1qTGAcDUHbvbhEx4ZCkyHykdQns HThE235/ewvOv1z5rzXkCF02o88yOZyeRG2Nx0Ircr52eC1DOnhNuJSdQFC2MK8XfUQrvk1x tEl0ZmEkJGOyMm1bk16n1Mnu0GtMdTE0QO3XVwMmct7iLwIDAQABozAwLjAeBgNVHREEFzAV gRNyamdvbnphbGVAZ21haWwuY29tMAwGA1UdEwEB/wQCMAAwDQYJKoZIhvcNAQEFBQADgYEA pfnn3ZnlLAw601z32gQkYQ/CTwrb/P/QbxVKQmhZHWtjFa8EXv5uIdnhPuxAFTDQVSDJZX6z Bz8O1MNkOv4nZZYohwwUxEdf4WajtLKo9YvX6OGZKiVtairp4eNTZg7E8Ml+VyXyiQvlvznL ib2WwIdLSq0hnUonmgWh3XMU7GUwggM/MIICqKADAgECAgENMA0GCSqGSIb3DQEBBQUAMIHR MQswCQYDVQQGEwJaQTEVMBMGA1UECBMMV2VzdGVybiBDYXBlMRIwEAYDVQQHEwlDYXBlIFRv d24xGjAYBgNVBAoTEVRoYXd0ZSBDb25zdWx0aW5nMSgwJgYDVQQLEx9DZXJ0aWZpY2F0aW9u IFNlcnZpY2VzIERpdmlzaW9uMSQwIgYDVQQDExtUaGF3dGUgUGVyc29uYWwgRnJlZW1haWwg Q0ExKzApBgkqhkiG9w0BCQEWHHBlcnNvbmFsLWZyZWVtYWlsQHRoYXd0ZS5jb20wHhcNMDMw NzE3MDAwMDAwWhcNMTMwNzE2MjM1OTU5WjBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhh d3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZy ZWVtYWlsIElzc3VpbmcgQ0EwgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGBAMSmPFVzVftO ucqZWh5owHUEcJ3f6f+jHuy9zfVb8hp2vX8MOmHyv1HOAdTlUAow1wJjWiyJFXCO3cnwK4Va qj9xVsuvPAsH5/EfkTYkKhPPK9Xzgnc9A74r/rsYPge/QIACZNenprufZdHFKlSFD0gEf6e2 0TxhBEAeZBlyYLf7AgMBAAGjgZQwgZEwEgYDVR0TAQH/BAgwBgEB/wIBADBDBgNVHR8EPDA6 MDigNqA0hjJodHRwOi8vY3JsLnRoYXd0ZS5jb20vVGhhd3RlUGVyc29uYWxGcmVlbWFpbENB LmNybDALBgNVHQ8EBAMCAQYwKQYDVR0RBCIwIKQeMBwxGjAYBgNVBAMTEVByaXZhdGVMYWJl bDItMTM4MA0GCSqGSIb3DQEBBQUAA4GBAEiM0VCD6gsuzA2jZqxnD3+vrL7CF6FDlpSdf0wh uPg2H6otnzYvwPQcUCCTcDz9reFhYsPZOhl+hLGZGwDFGguCdJ4lUJRix9sncVcljd2pnDmO jCBPZV+V2vf3h9bGCE6u9uo05RAaWzVNd+NWIXiC3CEZNd4ksdMdRv9dX2VPMYIDZDCCA2AC AQEwdjBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkg THRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0ECEFKu 3/n0oTKNim1sXE5AIgswCQYFKw4DAhoFAKCCAcMwGAYJKoZIhvcNAQkDMQsGCSqGSIb3DQEH ATAcBgkqhkiG9w0BCQUxDxcNMDcxMDE2MTUwMDM2WjAjBgkqhkiG9w0BCQQxFgQUzUzaLafs Qz5t6UXLGyfJMYKZ/PgwUgYJKoZIhvcNAQkPMUUwQzAKBggqhkiG9w0DBzAOBggqhkiG9w0D AgICAIAwDQYIKoZIhvcNAwICAUAwBwYFKw4DAgcwDQYIKoZIhvcNAwICASgwgYUGCSsGAQQB gjcQBDF4MHYwYjELMAkGA1UEBhMCWkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQ dHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENB AhBSrt/59KEyjYptbFxOQCILMIGHBgsqhkiG9w0BCRACCzF4oHYwYjELMAkGA1UEBhMCWkEx JTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0 ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBAhBSrt/59KEyjYptbFxOQCILMA0GCSqG SIb3DQEBAQUABIIBAGiAUaU6W0jiQcQXHNSvpobQKlhF7sxiEl+uEyiQOnASAhALfEY/v5Vn Vl3bUyyZiuHmguTyFlT3GxFWuy6gJ5cWP2vxq3Fl12Xm/72dBFh25hNbrmguG/7qBNuUb55r DkkAGKIjA8uctX3sPIFURt0B4noRkBNeVAAs0FDOTrtaCzhc8OF1exUsShiCQObwgZc+qDJq cKLvVLnlCi6WqgOmMoHuIKCKebbX4hE+plJBzQhp3flZGFSnNH9+57yfC3LFPgdLFCkBRmCr AQbzW7GEeFS8zQPRZfxVOAIRPayZYATFKtJneAt9Ytu89+MWCPVBCWF06kLCpbZerq5KrXwA AAAAAAA= --------------ms090802080403060506090701--