| From: | Curt Sampson <cjs(at)cynic(dot)net> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | David Gilbert <dgilbert(at)velocet(dot)ca>, Thomas O'Connell <tfo(at)monsterlabs(dot)com>, <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: performance tuning: shared_buffers, sort_mem; swap |
| Date: | 2002-08-15 04:57:24 |
| Message-ID: | Pine.NEB.4.44.0208151356170.1718-100000@angelic.cynic.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)cynic(dot)net> +81 90 7737 2974 http://www.netbsd.org
Don't you know, in this new Dark Age, we're all light. --XTC
| From | Date | Subject | |
|---|---|---|---|
| Next Message | shreedhar | 2002-08-15 07:47:39 | How can I replace 'Enter Character' to 'balnk space character' |
| Previous Message | shreedhar | 2002-08-15 04:55:05 | Is there any UNIT TESTING tool for postgre |