Re: Postgres not using shared memory - Mailing list pgsql-general

From Karl O. Pinc
Subject Re: Postgres not using shared memory
Date
Msg-id 20041216124859.E18657@mofo.meme.com
Whole thread Raw
In response to Re: Postgres not using shared memory  (Doug McNaught <doug@mcnaught.org>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Jonathan Hedstrom
Date:
Subject: use pg_catalog for foreign key constraint
Next
From: Tom Lane
Date:
Subject: Re: use pg_catalog for foreign key constraint