Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 34E6B64FCC7 for ; Fri, 19 Sep 2008 11:29:37 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 47844-01 for ; Fri, 19 Sep 2008 11:29:33 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from rv-out-0506.google.com (rv-out-0506.google.com [209.85.198.236]) by postgresql.org (Postfix) with ESMTP id B162E64FCDD for ; Fri, 19 Sep 2008 11:29:33 -0300 (ADT) Received: by rv-out-0506.google.com with SMTP id b25so404613rvf.43 for ; Fri, 19 Sep 2008 07:29:32 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:cc:in-reply-to:mime-version:content-type:references; bh=yMvl1OLFxhpRQ9pj4Exx/Ry2s5AFVyj8YPNbj1LCYxM=; b=RuyL3h/vMNUoe8nc3iLTJINRIV6X/fqbuuuOXyR337MnQBNVPFr/4gEDZtNy+N6sdp g7G/jC/o5UYCdgWxNu1oTY5lhyaR/aCKyjUBBC0G7NXXTiGz2g+7QdatY18rYpi+5rIk wljdnEg3+MDDdv6CKnhV6T14vrp02cfEosqTg= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version :content-type:references; b=HIRtKJv/E6qyod+JY59NazNuQuJUcyM/NT9QaU+9RakLaB0nQKJxunMXoNiTmglMko COb1xgEUOOFBoWUiJohyLl6PmCbqC00cPmTWX1+5hc33JoWFQ9AwQXZrnvqsVJTUbruK gXyrLXabTr1EbQwMFauBAXeS5ksiutM0vSFnM= Received: by 10.141.87.13 with SMTP id p13mr91933rvl.43.1221834572172; Fri, 19 Sep 2008 07:29:32 -0700 (PDT) Received: by 10.141.74.11 with HTTP; Fri, 19 Sep 2008 07:29:32 -0700 (PDT) Message-ID: Date: Fri, 19 Sep 2008 08:29:32 -0600 From: "Scott Marlowe" To: "c k" Subject: Re: Multi-processors Cc: pgsql-admin@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_Part_44040_15173412.1221834572167" References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200809/216 X-Sequence-Number: 30309 ------=_Part_44040_15173412.1221834572167 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline On Fri, Sep 19, 2008 at 5:55 AM, c k wrote: > Hello PG Community, > Does PG uses multiple processors/cores if available by default on various > OSes? Yes, see attached top extract from my primary db server at work > What are the limitations on using multiple processors/cores and main > memory? Do you mean how many CPUs and how much memory? no real limits on a 64 bit machine. Note that it's often better to let the os do the majority of caching, depending on your work load. This is especially true in OLTP where the cost of pgsql maintaining a large buffer is higher than the benefit it provides, but the kernel can cache much larger datasets faster, in my experience. ------=_Part_44040_15173412.1221834572167 Content-Type: text/plain; name=db-top.txt Content-Transfer-Encoding: base64 X-Attachment-Id: f_flawosj60 Content-Disposition: attachment; filename=db-top.txt dG9wIC0gMDg6Mjc6MDMgdXAgMzggZGF5cywgMTk6MTAsICAxIHVzZXIsICBsb2FkIGF2ZXJhZ2U6 IDMuNjcsIDQuMjYsIDQuMzkKVGFza3M6IDMxNiB0b3RhbCwgICA4IHJ1bm5pbmcsIDMwOCBzbGVl cGluZywgICAwIHN0b3BwZWQsICAgMCB6b21iaWUKQ3B1MCAgOiAxMC40JXVzLCAgMC45JXN5LCAg MC4wJW5pLCA4OC43JWlkLCAgMC4wJXdhLCAgMC4wJWhpLCAgMC4wJXNpLCAgMC4wJXN0CkNwdTEg IDogMjEuNiV1cywgIDUuMiVzeSwgIDAuMCVuaSwgNzMuMyVpZCwgIDAuMCV3YSwgIDAuMCVoaSwg IDAuMCVzaSwgIDAuMCVzdApDcHUyICA6ICA0LjMldXMsICAxLjclc3ksICAwLjAlbmksIDkzLjEl aWQsICAwLjAld2EsICAwLjAlaGksICAwLjklc2ksICAwLjAlc3QKQ3B1MyAgOiAxNC44JXVzLCAg MC45JXN5LCAgMC4wJW5pLCA4My41JWlkLCAgMC4wJXdhLCAgMC4wJWhpLCAgMC45JXNpLCAgMC4w JXN0CkNwdTQgIDogNTEuMyV1cywgIDIuNiVzeSwgIDAuMCVuaSwgNDYuMSVpZCwgIDAuMCV3YSwg IDAuMCVoaSwgIDAuMCVzaSwgIDAuMCVzdApDcHU1ICA6IDQ3LjgldXMsICAyLjYlc3ksICAwLjAl bmksIDQ4LjclaWQsICAwLjAld2EsICAwLjAlaGksICAwLjklc2ksICAwLjAlc3QKQ3B1NiAgOiA1 Ny40JXVzLCAgMi42JXN5LCAgMC4wJW5pLCA0MC4wJWlkLCAgMC4wJXdhLCAgMC4wJWhpLCAgMC4w JXNpLCAgMC4wJXN0CkNwdTcgIDogNjIuNiV1cywgIDQuMyVzeSwgIDAuMCVuaSwgMjYuMSVpZCwg IDAuMCV3YSwgIDAuOSVoaSwgIDYuMSVzaSwgIDAuMCVzdApNZW06ICAzMzAzMTI1MmsgdG90YWws IDMwODU4NTcyayB1c2VkLCAgMjE3MjY4MGsgZnJlZSwgICA1MjE2NDRrIGJ1ZmZlcnMKU3dhcDog IDk3Njc0ODBrIHRvdGFsLCAgICAgODAzMmsgdXNlZCwgIDk3NTk0NDhrIGZyZWUsIDI3NDU3MzUy ayBjYWNoZWQKCiAgUElEIFVTRVIgICAgICBQUiAgTkkgIFZJUlQgIFJFUyAgU0hSIFMgJUNQVSAl TUVNICAgIFRJTUUrICBDT01NQU5EICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgCjEzODI3IHBvc3RncmVzICAxNiAgIDAgODM1M20gMTEybSAx MDNtIFIgICAzNyAgMC4zICAgMDowMS4zNyBwb3N0Z3Jlczogd2ViZ3V5IHd3dyAxMC4wLjAuNTko NDMwODEpIFNFTEVDVCAgICAgICAgICAgICAgICAgICAgCjExMTE1IHBvc3RncmVzICAxNSAgIDAg ODM2M20gMi4wZyAyLjBnIFIgICAzMiAgNi4zICAgNzo0NC40MSBwb3N0Z3Jlczogd2ViZ3V5IHd3 dyAxMC4wLjAuNTgoNDIwNjYpIFNFTEVDVCAgICAgICAgICAgICAgICAgICAgCjEzNjUxIHBvc3Rn cmVzICAxNSAgIDAgODM1OG0gNDI2bSA0MTZtIFMgICAyNSAgMS4zICAgMDowNC43MCBwb3N0Z3Jl czogd2ViZ3V5IHd3dyAxMC4wLjAuNTIoNTkyMjApIGlkbGUgICAgICAgICAgICAgICAgICAgICAg CjEzNzQ2IHBvc3RncmVzICAxNSAgIDAgODM2MG0gMzk2bSAzODRtIFMgICAyMCAgMS4yICAgMDow My40NCBwb3N0Z3Jlczogd2ViZ3V5IHd3dyAxMC4wLjAuNTgoNTMyNDQpIGlkbGUgICAgICAgICAg ICAgICAgICAgICAgCjEzNzc1IHBvc3RncmVzICAxNSAgIDAgODM1N20gNDAzbSAzOTRtIFMgICAy MCAgMS4zICAgMDowMy4yNSBwb3N0Z3Jlczogd2ViZ3V5IHd3dyAxMC4wLjAuNTkoMzg1NTApIGlk bGUgICAgICAgICAgICAgICAgICAgICAgCjEzODQwIHBvc3RncmVzICAxNSAgIDAgODM1NW0gMTM4 bSAxMzBtIFMgICAxNiAgMC40ICAgMDowMS44MSBwb3N0Z3Jlczogd2ViZ3V5IHd3dyAxMC4wLjAu NTgoNjA1NTQpIGlkbGUgICAgICAgICAgICAgICAgICAgICAgCjEzODEzIHBvc3RncmVzICAxNiAg IDAgODM1N20gMzcybSAzNjJtIFIgICAxMyAgMS4yICAgMDowMi40NCBwb3N0Z3Jlczogd2ViZ3V5 IHd3dyAxMC4wLjAuNTkoNDE3MjMpIFNFTEVDVCAgICAgICAgICAgICAgICAgICAgCjEzODkzIHBv c3RncmVzICAxNSAgIDAgODM0OW0gIDI4bSAgMjVtIFMgICAxMCAgMC4xICAgMDowMC4xNCBwb3N0 Z3Jlczogd2ViZ3V5IHd3dyAxMC4wLjAuNTIoNDc3NzYpIGlkbGUgICAgICAgICAgICAgICAgICAg ICAgCjEzNTk4IHBvc3RncmVzICAxNSAgIDAgODM2MG0gNTY2bSA1NTNtIFMgICAgOSAgMS44ICAg MDoxMi40MiBwb3N0Z3Jlczogd2ViZ3V5IHd3dyAxMC4wLjAuNTkoNTU2OTYpIGlkbGUgICAgICAg ICAgICAgICAgICAgICAgCjEzODU0IHBvc3RncmVzICAxNSAgIDAgODM1NW0gIDkybSAgODRtIFMg ICAgOSAgMC4zICAgMDowMC45MCBwb3N0Z3Jlczogd2ViZ3V5IHd3dyAxMC4wLjAuNTkoNDQ5MDkp IGlkbGUgICAgICAgICAgICAgICAgICAgICAgCjEzNzE4IHBvc3RncmVzICAxNSAgIDAgODM1OG0g NDM3bSA0MjZtIFMgICAgOCAgMS40ICAgMDowOC41NSBwb3N0Z3Jlczogd2ViZ3V5IHd3dyAxMC4w LjAuNTkoMzQxNzcpIGlkbGUgICAgICAgICAgICAgICAgICAgICAgCjEzNzk0IHBvc3RncmVzICAx NSAgIDAgODM1NG0gIDMybSAgMjdtIFMgICAgOCAgMC4xICAgMDowMC4yNiBwb3N0Z3Jlczogd2Vi Z3V5IHd3dyAxMC4wLjAuMTUzKDM2MjczKSBpZGxlICAgICAgICAgICAgICAgICAgICAgCjEzODIw IHBvc3RncmVzICAxNSAgIDAgODM1OG0gMTk0bSAxODRtIFMgICAgOCAgMC42ICAgMDowMi4wMyBw b3N0Z3Jlczogd2ViZ3V5IHd3dyAxMC4wLjAuNTgoNTg5NjIpIGlkbGUgICAgICAgICAgICAgICAg ICAgICAgCjEzNzkxIHBvc3RncmVzICAxNSAgIDAgODM1OW0gMjU4bSAyNDZtIFMgICAgNyAgMC44 ICAgMDowNC4zMCBwb3N0Z3Jlczogd2ViZ3V5IHd3dyAxMC4wLjAuNTkoNDAwMDcpIGlkbGUgICAg ICAgICAgICAgICAgICAgICAgCjEzNDM5IHBvc3RncmVzICAxNSAgIDAgODM1OG0gNjA0bSA1OTRt IFMgICAgNiAgMS45ICAgMDoxMC4wNiBwb3N0Z3Jlczogd2ViZ3V5IHd3dyAxMC4wLjAuNTgoMzMy MTIpIGlkbGUgICAgICAgICAgICAgICAgICAgICAgCjEzNTcwIHBvc3RncmVzICAxNiAgIDAgODM1 OW0gMzIybSAzMTFtIFMgICAgNiAgMS4wICAgMDowOS41MSBwb3N0Z3Jlczogd2ViZ3V5IHd3dyAx MC4wLjAuNTgoNDE3NDcpIGlkbGUgICAgICAgICAgICAgICAgICAgICAgCjEzNzM2IHBvc3RncmVz ICAxNSAgIDAgODM1OW0gMzAwbSAyODltIFMgICAgNiAgMC45ICAgMDowNC41MCBwb3N0Z3Jlczog d2ViZ3V5IHd3dyAxMC4wLjAuNTkoMzYyMTIpIGlkbGUgICAgICAgICAgICAgICAgICAgICAgCjEz ODA5IHBvc3RncmVzICAxNSAgIDAgODM1MW0gMjI5bSAyMTltIFIgICAgNSAgMC43ICAgMDowMi4w NSBwb3N0Z3Jlczogd2ViZ3V5IHd3dyAxMC4wLjAuNTgoNTc5NzQpIFNFTEVDVCAgICAgICAgICAK ------=_Part_44040_15173412.1221834572167--