Hello...

From: Kevin Brown <Kevin(dot)M(dot)Brown(at)asu(dot)edu>
To: "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org>
Subject: Hello...
Date: 2001-06-05 15:39:11
Message-ID: A021872EC2BDD411AB3600902746A05501375354@mainex4.asu.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I've got a small problem and thought someone here might be able to help
solve it. Recently I upgraded one of the linux servers with PostgreSQL v7.1
from v7.0.3 to get support for OUTER JOINS amongst other things for a
project here at work (running a Snort NIDS logging to an SQL server).

My current setup:

Quad PII 450
2GB RAM
RH Linux 6.2, Kernel 2.2.16 (SMP enabled)

Under v7.0.3, if I ran multiple queries on this box they would each run on a
different processor and wouldn't impact on each others performance until I
ran more queries than CPUs. Now when I run queries they all stay on one
processor and cause the queries to take longer by fighting for resources.

I start psql with the init script that came with the RPM (binary install
gotten from postgresql mirror):
su -l postgres -c "LC_ALL=C /usr/bin/pg_ctl -D $PGDATA -o '-i -F' -p
/usr/bin/postmaster start >/dev/null 2>&1" < /dev/null

Is there some configuration option I need to setup to get it to work with
all 4 cpus?

Sorry if this has been asked before, but I couldn't find an answer by
searching the lists or reading through the docs.

Begin Geek Code;
$_='while(read+STDIN,$_,2048){$a=29;$b=73;$c=142;$t=255;@t=map{$_%16or$t^=$c
^=(
$m=(11,10,116,100,11,122,20,100)[$_/16%8])&110;$t^=(72,@z=(64,72,$a^=12*($_%
16
-2?0:$m&17)),$b^=$_%64?12:0,@z)[$_%8]}(16..271);if((@a=unx"C*",$_)[20]&48){$
h
=5;$_=unxb24,join"",@b=map{xB8,unxb8,chr($_^$a[--$h+84])}(at)ARGV;s/...$/1$&/;$
d=unxV,xb25,$_;$e=256|(ord$b[4])<<9|ord$b[3];$d=$d>>8^($f=$t&($d>>12^$d>>4^
$d^$d/8))<<17,$e=$e>>8^($t&($g=($q=$e>>14&7^$e)^$q*8^$q<<6))<<9,$_=$t[$_]^
(($h>>=8)+=$f+(~$g&$t))for(at)a[128(dot)(dot)$#a]}print+x"C*",@a}';s/x/pack+/g;eval

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2001-06-05 17:29:07 Re: Hello...
Previous Message Roy Souther 2001-06-05 15:37:17 Corrupted database, how do I fix?