Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 71780632CF2 for ; Sun, 14 Feb 2010 14:25:23 -0400 (AST) 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 07942-07 for ; Sun, 14 Feb 2010 18:25:12 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-ew0-f214.google.com (mail-ew0-f214.google.com [209.85.219.214]) by mail.postgresql.org (Postfix) with ESMTP id CC838632CB2 for ; Sun, 14 Feb 2010 14:25:12 -0400 (AST) Received: by ewy6 with SMTP id 6so1674271ewy.34 for ; Sun, 14 Feb 2010 10:25:11 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:cc:content-type; bh=pt+N043/elrEx2YW8dBDHOtJxNk5EnSrkIlaUbOiL6w=; b=CgCqyYXKNewc1vQHZsNvAbdXPZdtW4t8nW8fAe3vz4w2VfhHa/esjyxnrh/4nyWGjP EVsxjOJCxwGQFJ3Od/FftBsumkHw5NfjjY1ScX8OIPHnped4Le9KNsh2LLuIchrlzRwd OKxxSp2p5BulpD9HdPJeUuh7TIl7gM9VWRrsU= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; b=XNg1oYti6VVI9ElrZmsnP647q3+O5kovkwOkIHEAjiQ/HLzGq5AffOi7ZHlVd/s/1T iseYEnWArUDt9KkcTi5tSyWhKbZffBbGRYDBjSo/bAqLhMaknhgFHT7I6g0tQwv4qHPZ P5j7/iquCSuG3V6JrBrNd96NtVmH2RvEgiddw= MIME-Version: 1.0 Received: by 10.216.85.68 with SMTP id t46mr621264wee.114.1266171911099; Sun, 14 Feb 2010 10:25:11 -0800 (PST) In-Reply-To: <4DA8D3EC-9868-4A6D-8806-F0534C55D2C6@gmail.com> References: <4DA8D3EC-9868-4A6D-8806-F0534C55D2C6@gmail.com> Date: Sun, 14 Feb 2010 11:25:11 -0700 Message-ID: Subject: Re: PostgreSQL on SMP Architectures From: Scott Marlowe To: Reydan Cankur Cc: pgsql-performance@postgresql.org Content-Type: text/plain; charset=ISO-8859-1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5 tests=BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201002/227 X-Sequence-Number: 37648 With all that info, your question is still kind of vague. Do you want to be able to run a single query across all 64 cores? Or do you have 1,000 users and you want them to be spread out on all cores. PostgreSQL can do the second but has no native features to do the first.