Re: performance tuning: shared_buffers, sort_mem; swap - Mailing list pgsql-admin

From Curt Sampson
Subject Re: performance tuning: shared_buffers, sort_mem; swap
Date
Msg-id Pine.NEB.4.44.0208151356170.1718-100000@angelic.cynic.net
Whole thread Raw
In response to Re: performance tuning: shared_buffers, sort_mem; swap  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
On Wed, 14 Aug 2002, Tom Lane wrote:

> > One bonus of bsd shared memory (when anonymous) is that it dies with
> > the process ... even in the worst case.
>
> But in fact we don't *want* it to be anonymous.

Just as a little further explanation here, postgres on startup will
check for an exiting SHM segment and use the information from that
to help recover (since its existence alone is an indication that
an unclean shutdown ocurred).

But yeah, dig through the archives and you'll see more than you
ever wanted to know about this topic.

cjs
--
Curt Sampson  <cjs@cynic.net>   +81 90 7737 2974   http://www.netbsd.org
    Don't you know, in this new Dark Age, we're all light.  --XTC


pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Leftover processes on shutdown - Debian+JDBC
Next
From: "Nick Fankhauser"
Date:
Subject: Re: Leftover processes on shutdown - Debian+JDBC