optimizing

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

Browse pgsql-general by date

  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