Re: Postgres not using shared memory

From: "Karl O(dot) Pinc" <kop(at)meme(dot)com>
To: Doug McNaught <doug(at)mcnaught(dot)org>, d(at)commandprompt(dot)com, kleptog(at)svana(dot)org
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Postgres not using shared memory
Date: 2004-12-16 18:48:59
Message-ID: 20041216124859.E18657@mofo.meme.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On 2004.12.10 15:30 Doug McNaught wrote:
> "Karl O. Pinc" <kop(at)meme(dot)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(at)meme(dot)com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Guy Rouillier 2004-12-16 19:12:20 Re: pl/pgsql oddity
Previous Message Geoffrey 2004-12-16 18:39:38 Re: pl/pgsql oddity