Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 876CC9FB1F3 for ; Sun, 15 Apr 2007 20:29:31 -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 05762-08 for ; Sun, 15 Apr 2007 20:29:30 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from weatherbeeta.com.au (218-214-212-153.people.net.au [218.214.212.153]) by postgresql.org (Postfix) with SMTP id E46EA9FB214 for ; Sun, 15 Apr 2007 20:29:27 -0300 (ADT) Received: (qmail 15934 invoked from network); 15 Apr 2007 23:29:24 -0000 X-NetworkBox-HamSign: 0101;OUT;wbeetaau1;b9f9edc269d0ac1adf8deb96644a2b56; Received: from mail.weatherbeeta.com.au (10.10.0.2) by network-box.weatherbeeta.com.au with SMTP; 15 Apr 2007 23:29:24 -0000 Received: (qmail 23394 invoked by uid 1166); 16 Apr 2007 09:29:17 +1000 Received: from 172.20.0.155 by mail.weatherbeeta.com.au (envelope-from , uid 1165) with qmail-scanner-1.25-st-qms (clamdscan: 0.88.6/2315. perlscan: 1.25-st-qms. Clear:RC:1(172.20.0.155):. Processed in 4.041993 secs); 15 Apr 2007 23:29:20 -0000 X-Antivirus-mail.weatherbeeta.com.au-Mail-From: phillip.smith@weatherbeeta.com.au via mail.weatherbeeta.com.au X-Antivirus-mail.weatherbeeta.com.au: 1.25-st-qms (Clear:RC:1(172.20.0.155):. Processed in 4.041993 secs Process 23363) Received: from it-phil.weatherbeeta.com.au (HELO wbaus090) (172.20.0.155) by mail.weatherbeeta.com.au with SMTP; 16 Apr 2007 09:29:10 +1000 From: "Phillip Smith" To: , Subject: Re: REINDEX using only 1 CPU (of 2) Date: Mon, 16 Apr 2007 09:29:01 +1000 Organization: Weatherbeeta Pty Ptd Message-ID: <007401c77fb5$d9886030$9b0014ac@wbaus090> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.6626 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962 In-Reply-To: <532476.32746.qm@web50303.mail.re2.yahoo.com> Importance: Normal X-Scanned-By-wbeetaau1: Virus scan performed by network-box X-Scanned-By-wbeetaau1: Scanner file id is wbeetaau1-1176679764.380-15925-000 X-Scanned-By-wbeetaau1: No known viruses found in message (received+scanned in 0.02/0.18 secs) X-Scanned-By-wbeetaau1: Spam-Check-Result: No, hits=0 required=7 tests= autolearn=no version=2.0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/138 X-Sequence-Number: 25202 A REINDEX is one process - you can't split one process over 2 CPU's. If you start another process (a SELECT / UPDATE / INSERT for example), = that process (should) use the other processor. Cheers, ~p -----Original Message----- From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of ogjunk-pgjedan@yahoo.com Sent: Saturday, 14 April 2007 10:55 To: pgsql-admin@postgresql.org Subject: [ADMIN] REINDEX using only 1 CPU (of 2) 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 ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate *******************Confidentiality and Privilege Notice******************* The material contained in this message is privileged and confidential to the addressee. If you are not the addressee indicated in this message or responsible for delivery of the message to such person, you may not copy or deliver this message to anyone, and you should destroy it and kindly notify the sender by reply email. Information in this message that does not relate to the official business of Weatherbeeta must be treated as neither given nor endorsed by Weatherbeeta. Weatherbeeta, its employees, contractors or associates shall not be liable for direct, indirect or consequential loss arising from transmission of this message or any attachments