Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id F31F89F9914 for ; Wed, 5 Sep 2007 20:02:47 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 70792-01 for ; Wed, 5 Sep 2007 20:02:38 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from nz-out-0506.google.com (nz-out-0506.google.com [64.233.162.228]) by postgresql.org (Postfix) with ESMTP id B86BD9F9856 for ; Wed, 5 Sep 2007 20:02:38 -0300 (ADT) Received: by nz-out-0506.google.com with SMTP id l8so1242568nzf for ; Wed, 05 Sep 2007 16:02:37 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=XBox1MJsWqiOHkQsIRDe0IRaJU6UZ3SyfWcufyXrs8cTT9KcoeX9p4RUK/INyO2+3YPkg8H4kZDh1JrWShusts8rOlsKXxNvugHpU4abfbHzuPM0eZz1921dqAj/BqSNYRvcbdacGWYyHIeovGMvs4fXXEZRDdI+zdBT5/xKZTI= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=F0HqXUcWZQBIXc7WRExFAIdHmunpcnN7TPBtK5MTn8yFuXb8l/o6a3cTKkSrpHq9KwIkS1FSJT17J0XbMeX6FouBa9+TpO36apwG54UARaFFbVMFzuJ1hMAbCSw5mi0PO9MXEZTyGi3uXZZmBPcRMS9KZ9I3g3/Bk0Tyd8Fsrfc= Received: by 10.143.165.13 with SMTP id s13mr397486wfo.1189033356635; Wed, 05 Sep 2007 16:02:36 -0700 (PDT) Received: by 10.143.8.5 with HTTP; Wed, 5 Sep 2007 16:02:36 -0700 (PDT) Message-ID: <36e682920709051602g446f538cta9dca4447c2b39fb@mail.gmail.com> Date: Wed, 5 Sep 2007 19:02:36 -0400 From: "Jonah H. Harris" To: "Thomas Finneid" Subject: Re: utilising multi-cpu/core machines? Cc: pgsql-performance@postgresql.org In-Reply-To: <46DF3082.7040301@ifi.uio.no> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <46DF3082.7040301@ifi.uio.no> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/66 X-Sequence-Number: 26611 On 9/5/07, Thomas Finneid wrote: > how does pg utilise multi cpus/cores, i.e. does it use more than one > core? and possibly, how, are there any documentation about this. Unlike other systems which manage their own affinity and prioritization, Postgres relies solely on the OS to handle process management across multiple CPUs/cores. -- Jonah H. Harris, Software Architect | phone: 732.331.1324 EnterpriseDB Corporation | fax: 732.331.1301 33 Wood Ave S, 3rd Floor | jharris@enterprisedb.com Iselin, New Jersey 08830 | http://www.enterprisedb.com/