Re: [ADMIN] REINDEX using only 1 CPU (of 2)

2007-04-15 Thread Phillip Smith
PROTECTED] 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

Re: [ADMIN] REINDEX using only 1 CPU (of 2)

2007-04-14 Thread Peter Eisentraut
[EMAIL PROTECTED] 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

[ADMIN] REINDEX using only 1 CPU (of 2)

2007-04-13 Thread ogjunk-pgjedan
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