From: | Roger Wernersson <rw(at)mindark(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | optimizing |
Date: | 2001-05-03 16:29:23 |
Message-ID: | 3AF18763.4B5410F2@mindark.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Martín Marqués | 2001-05-03 16:56:49 | date problem |
Previous Message | Gyozo Papp | 2001-05-03 16:19:10 | Re: [PHP] psql with PHP question |