optimizing - Mailing list pgsql-general

From Roger Wernersson
Subject optimizing
Date
Msg-id 3AF18763.4B5410F2@mindark.com
Whole thread Raw
List pgsql-general
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

pgsql-general by date:

Previous
From: "Othman Laraki"
Date:
Subject: Can't get Postgres to use indices
Next
From: "Witold Rak"
Date:
Subject: How tnaslate kode from MySQL to Postgres?