Обсуждение: optimizing

Поиск
Список
Период
Сортировка

optimizing

От
Roger Wernersson
Дата:
Hi all!

I'm running a Postgres 6.4 installation (yes, will upgrade to 7 soon) on
a redHat 6.2. I have about 25 databases, each using up to 35MB at the
moment (they will grow in size, but not in numbers). It's a dual
processor machine with 1GB memory and 40GB disk. How do I make the most
out of this database server? Can I load the databases into memory and
run faster?

I have tried some optimizations myself, but...

When I try using a simple
  /usr/bin/postmaster -B 2048 -D/var/lib/pgsql -N 64 -S -i -o -F

and then connect, "ps ax" gives me this:
  /usr/bin/postmaster -B 2048 -D/var/lib/pgsql -N 64 -S -i -o -F
  /usr/bin/postgres localhost roger roger idle

Why doesn't the "-F" add to the parameters of "postgres"?

/Roger