With my hard drive issues from an earlier email solved (thanks all) I am now running queries against my 65M rows. I noticed in atop that postmaster is using 100% of just one processor core. Is there any way to tell it to use both (or at least some of the other one). System is RHEL5, PG is version 8.1.18 on x86_64-redhat-linux-gnu, compiled by GCC gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-46). Intel Core 2 Duo, 4 GB RAM.
The query in question has been running for 15 minutes, and the only thing atop is reporting in the "red" is the processor. Although, just now the proc has died down and the drive is apparently now "red" (the main delay point). Here is the query (any help on improving it?) ------------------------------ | a | b | --------------|--------------- |guid vc(32) | guid vc(32) | |unitid vc(15)| unitid vc(15)| |ftime ts | | |source vc(10)| | ------------------------------ |65,000,000 rw| 500,000 rows | ------------------------------ SELECT DISTINCT guid FROM b WHERE guid NOT IN (SELECT DISTINCT guid FROM a) AND unitid IN (SELECT DISTINCT unitid FROM a) Eventually, I want to project b.unitid and group by it, with a count(b.guid). -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
