Hi Peter,
> GB is just a typo I guess?
No, it isn't a typo. I meant it.
> Otherwise the value is insanely high.
I kinda agree, but I am in a process of finding an
equilibrium for my application. (I must admit I am
doing so in a bit of blind fashion, but that's kinda
where I am at.)
As I look at top utility's %MEM column as postgres
processes run under duress, it never goes beyond 1.9.
To me, that's like not using what is available. When
I see a larger number for %MEM, I will readjust as
necessary.
In a previous correspondence, Scott said I was mild
in terms of postgres parameter tuning. Maybe I can
get him to say I am doing something WILD?! ;)
Regards,
Tena Sakai
tsakai@gallo.ucsf.edu
-----Original Message-----
From: Jan-Peter Seifert [mailto:Jan-Peter.Seifert@gmx.de]
Sent: Sat 2/21/2009 5:45 AM
To: Tena Sakai; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] very, very slow performance
Hello,
> I have adjusted postgres parameters per your recommen-
> dation. Work_mem is now 8GB,
GB is just a typo I guess? Otherwise the value is insanely high. See:
http://www.postgresql.org/docs/8.3/interactive/runtime-config-resource.html
Peter