On 2004.12.10 15:30 Doug McNaught wrote:
"Karl O. Pinc" <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
