Postmaster startup options (was: 50 MB Table)

From: "Steve Wolfe" <steve(at)iboats(dot)com>
To: <pgsql-general(at)postgreSQL(dot)org>
Subject: Postmaster startup options (was: 50 MB Table)
Date: 2000-03-08 18:53:49
Message-ID: 002301bf892f$a43b6f50$85755ad1@iboats.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> postmaster -i -B 12000 -d 2 -o "-F -S 4096 -s" >&! server.log &

I tried to find some documentation on the "-F" command, but couldn't.
"-S" appears to mean that it should be silent, so I'm not sure what "-S
4096" does. If anyone could point me towards relevant information, I would
be very happy.

> The "-B 12000" tells Postgres to set aside 12,000 8k buffers. With the
size
> of your table, you should easily be able to fit the whole thing into
memory.
> Keep in mind that your OS must have it's shared memory segment defined
large
> enough to handle all the buffers... in this case, about 100 Meg.

And, while I'm at it, if anyone is kind enough, how exactly do I go about
increasing the shared memory segment on a Linux 2.2 kernel?

steve

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Henk van Lingen 2000-03-08 20:37:27 Re: [GENERAL] moddatetime / insert_username
Previous Message kaiq 2000-03-08 16:47:10 Cancel => mydate >'TODAY' not working on 6.5.1 with dbi (fwd)