Re: [PERFORM] Help how to tune-up my Database

2004-05-11 Thread Bricklen
scott.marlowe wrote: Sorry about that, I meant kbytes, not megs. My point being it's NOT measured in 8k blocks, like a lot of other settings. sorry for the mixup. No worries, I just wanted to sort that out for my own benefit, and anyone else who may not have caught that.

Re: [PERFORM] Help how to tune-up my Database

2004-05-10 Thread scott.marlowe
Sorry about that, I meant kbytes, not megs. My point being it's NOT measured in 8k blocks, like a lot of other settings. sorry for the mixup. On Fri, 7 May 2004, Bricklen wrote: > scott.marlowe wrote: > > sort_mem might do with a small bump, especially if you're only handling a > > few connec

Re: [PERFORM] Help how to tune-up my Database

2004-05-10 Thread Bricklen
scott.marlowe wrote: sort_mem might do with a small bump, especially if you're only handling a few connections at a time. Be careful, it's per sort, and measured in megs, so it's easy for folks to set it too high and make their machine start flushing too much kernel cache, which will slow down

Re: [PERFORM] Help how to tune-up my Database

2004-05-07 Thread scott.marlowe
On Fri, 7 May 2004, Michael Ryan S. Puncia wrote: > Hi, > > I am a newbie here and just starting to use postgresql. My > problems is how to tune up my server because it its too slow. First, read this: http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html > This is my PC spec

[PERFORM] Help how to tune-up my Database

2004-05-07 Thread Michael Ryan S. Puncia
Hi,     I am a newbie here and just starting to use postgresql. My problems is how to tune up my server because it its too slow. We just ported from DBF to postgresql.   This is my PC specs: P4, 512Ram, Linux 9   Because I am working in a statistical organization we have a ver