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
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) |