Postmaster startup options (was: 50 MB Table) - Mailing list pgsql-general

From Steve Wolfe
Subject Postmaster startup options (was: 50 MB Table)
Date
Msg-id 002301bf892f$a43b6f50$85755ad1@iboats.com
Whole thread Raw
In response to RE: [GENERAL] 50 MB Table  ("Culberson, Philip" <philip.culberson@dat.com>)
List 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


pgsql-general by date:

Previous
From: "Raigo Lukk"
Date:
Subject: Re: Trigger
Next
From: Henk van Lingen
Date:
Subject: Re: [GENERAL] moddatetime / insert_username