On 2004.12.10 15:30 Doug McNaught wrote:
> "Karl O. Pinc" <kop@meme.com> writes:
>
> > Hi,
> >
> > I can't seem to get postgresql to use shared memory and performance
> is
> > terrrible.
>
> 1) Linux doesn't track shared pages (which is not the same as shared
> memory) anymore--the field the in 'free' output is just there to
> avoid breaking software. Use the 'ipcs' command to list shared
> memory segments--you'll find Postgres is using what you told it to
> (otherwise it woudn't start up at all).
> 2) The -performance list is a good place to find out why queries are
> running slowly.
Thank you all for your replies and your help. I found out hours after
sending the original post that Linux does not report shared memory
in 'free', and for some reason the first time I tried 'ipcs' (before
I posted) I must have done something wrong because I wasn't seeing
it there either.
Moments after I posted the network crashed, and hilarity ensued.
It's taken me until now to get back to everybody, and determine
that my problems are not postgresql related.
Thanks again for the help and sorry for the delay in my response.
Karl <kop@meme.com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein