Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 1D50C9FB976 for ; Fri, 13 Apr 2007 21:55:11 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 46365-02 for ; Fri, 13 Apr 2007 21:55:01 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from web50303.mail.re2.yahoo.com (web50303.mail.re2.yahoo.com [206.190.38.57]) by postgresql.org (Postfix) with SMTP id 175919FB5C5 for ; Fri, 13 Apr 2007 21:55:05 -0300 (ADT) Received: (qmail 34708 invoked by uid 60001); 14 Apr 2007 00:55:04 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type:Message-ID; b=il6OHlbdQjKmgtUVajqDvktZsdVHz7YUGsmhIFGdX2Qn6iKV79rbPaQ2nHVnoQ7she1K3jnHQRFbDbuGJEHNS6a1DM1wJcwVqvCXKItoPSPIXPswSxRpKUFDsR1aM84FwgTT7ZyAgM6kprWQkg3WTXApDCsZMH4CAM1X+avBZmA=; X-YMail-OSG: YotgjUAVM1mBvEAXK42EtLREtVJGnvpu_uryQXSy6uy4iil.hWeLqKzJiaksrwJPiQ-- Received: from [72.231.8.153] by web50303.mail.re2.yahoo.com via HTTP; Fri, 13 Apr 2007 17:55:04 PDT X-Mailer: YahooMailRC/478 YahooMailWebService/0.7.41.10 Date: Fri, 13 Apr 2007 17:55:04 -0700 (PDT) From: ogjunk-pgjedan@yahoo.com Subject: REINDEX using only 1 CPU (of 2) To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=ascii Message-ID: <532476.32746.qm@web50303.mail.re2.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=4.317 tagged_above=0 required=5 tests=BAYES_50=0.001, DNS_FROM_RFC_ABUSE=0.2, DNS_FROM_RFC_POST=1.708, DNS_FROM_RFC_WHOIS=1.447, NO_REAL_NAME=0.961 X-Spam-Level: **** X-Archive-Number: 200704/134 X-Sequence-Number: 25198 Hi, I've got PG 8.2.3 running on a dual-core P4, and I noticed that, at least during reindexing, postgreSQL REINDEX process is using only 1 of those 2 cores. You can clearly see this from this snippet from top: Cpu0 : 93.3% us, 6.7% sy, 0.0% ni, 0.0% id, 0.0% wa, 0.0% hi, 0.0% si Cpu1 : 0.0% us, 2.6% sy, 0.0% ni, 85.5% id, 11.8% wa, 0.0% hi, 0.0% si PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 21909 pg 25 0 116m 89m 42m R 98.9 9.2 1:01.92 postgres: pg mydb [local] REINDEX This PG 8.2.3 was compiled from sources on this box, so if there is anything in the config/install process that should pick up that this box has "2" CPUs, perhaps that didn't happen? I know I didn't manually instruct the config/install that the box is a dual-core box. This is running on a Linux box with the SMP-aware kernel. Is this a known limitation? Am I reading this wrong? Thanks, Otis