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 tsa...@gallo.ucsf.edu -----Original Message----- From: Jan-Peter Seifert [mailto:jan-peter.seif...@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
