Re: [GENERAL] Tuning PostgreSQL to use more RAM...

2000-08-18 Thread Tom Lane
"Steve Wolfe" <[EMAIL PROTECTED]> writes: >While I don't mind disk cache, I feel that we could get better > performance by letting postgres use another hundred megs or so, especially > since our entire /usr/local/pgsql/base directory has only 134 megs of data. > We're currently starting the po

[GENERAL] Tuning PostgreSQL to use more RAM...

2000-08-15 Thread Steve Wolfe
> Actually, more RAM would permit you to increase both the -B parameters as > well as the -S one ... which are both noted for providing performance > increases ... -B more on repeative queries and -S on anything involving > ORDER BY or GROUP BY ... For a while now, I've been meaning to investi