Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 68A4D9FB470 for ; Sat, 14 Apr 2007 05:59:03 -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 00803-02 for ; Sat, 14 Apr 2007 05:59:02 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by postgresql.org (Postfix) with SMTP id 4F4159FB42F for ; Sat, 14 Apr 2007 05:58:32 -0300 (ADT) Received: (qmail invoked by alias); 14 Apr 2007 08:58:30 -0000 Received: from xdsl-87-78-212-71.netcologne.de (EHLO colt.pezone.net) [87.78.212.71] by mail.gmx.net (mp056) with SMTP; 14 Apr 2007 10:58:30 +0200 X-Authenticated: #495269 X-Provags-ID: V01U2FsdGVkX19Xp+5tjRNXP/sSJr7zyrzNx9F/0FE42JYROLvKMV e11a3aiJ1q36/y From: Peter Eisentraut To: pgsql-admin@postgresql.org Subject: Re: REINDEX using only 1 CPU (of 2) Date: Sat, 14 Apr 2007 10:58:25 +0200 User-Agent: KMail/1.9.5 Cc: ogjunk-pgjedan@yahoo.com References: <532476.32746.qm@web50303.mail.re2.yahoo.com> In-Reply-To: <532476.32746.qm@web50303.mail.re2.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200704141058.25505.peter_e@gmx.net> X-Y-GMX-Trusted: 0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/136 X-Sequence-Number: 25200 ogjunk-pgjedan@yahoo.com wrote: > 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. One process, one CPU (core) -- you can't do anything about that. -- Peter Eisentraut http://developer.postgresql.org/~petere/