On Sat, Feb 21, 2009 at 3:11 AM, Tena Sakai <tsakai@xxxxxxxxxxxxxx> wrote: > Hi Scott, > > Thanks for clustering suggestion. I have never used > cluster command and I need to read up before I can > use it. > > I have adjusted postgres parameters per your recommen- > dation. Work_mem is now 8GB, checkpoint_segments is > raised to 100. Shared_buffers is still at 1GB because > this is bound by SHMMAX of kernal, which I cannot alter > for maybe a few days. I am thinking of setting SHMMAX > to 8GB. Yeah, I'd reverse those two and set work_mem to something in the 512M range max. keep in mind work_mem is per query / per sort. 4 queries with3 sorts each = max allocation of work_mem*3*4... I may or may not be able to move up to 8.3.6 > over this weekend. If not, sometime during the week. definitely a good idea. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
