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