pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Greg Smith <gsmith@gregsmith.com>
Cc: Gregory Stark <stark@enterprisedb.com>
Cc: Kevin Murphy <murphy@genome.chop.edu>
Cc: pgsql-general@postgresql.org
Subject: Re: Drupal and PostgreSQL - performance issues?
Date: Wed, 15 Oct 2008 12:13:03 -0400
Message-ID: <22702.1224087183@sss.pgh.pa.us> (raw)
In-Reply-To: <Pine.GSO.4.64.0810150149220.27530@westnet.com>
References: <2434A118-CEFA-43A9-BA88-006EC1F80326@hoegh.org>
	<200810122214.53558.uwe@oss4u.com>
	<20081013090228.248a665f@dawn.webthatworks.it>
	<e7e0a2570810131945x1bbf10b8r67c0ac2a340b436f@mail.gmail.com>
	<20081014114011.0ebe495a@dawn.webthatworks.it>
	<3250B5B6-B507-4E79-BAF0-E98B73E9FED9@hoegh.org>
	<Pine.GSO.4.64.0810140942010.28645@westnet.com>
	<48F4B3C2.1050805@genome.chop.edu>
	<Pine.GSO.4.64.0810141747240.5472@westnet.com>
	<87od1mbpsv.fsf@oxford.xeocode.com>
	<Pine.GSO.4.64.0810150149220.27530@westnet.com>

Greg Smith <gsmith@gregsmith.com> writes:
> If there were ever any Linux distributions that increased this value from 
> the tiny default, you might have a defensible position here (maybe 
> Oracle's RHEL fork does, they might do something here).  I've certainly 
> never seen anything besides Solaris ship with a sensible SHMMAX setting 
> for database use on 2008 hardware out of the box.  It's really quite odd, 
> but as numerous probes in this area (from the above in 2000 to Peter's 
> recent Linux bugzilla jaunt) show the resistance to making the OS default 
> to any higher is considerable.

I think the subtext there is that the Linux kernel hackers hate the SysV
IPC APIs and wish they'd go away.  They are presently constrained from
removing 'em by their desire for POSIX compliance, but you won't get
them to make any changes that might result in those APIs becoming more
widely used :-(

Mind you, I find the SysV APIs uselessly baroque too, but there is one
feature that we have to have that is not in mmap(): the ability to
detect other processes attached to a shmem block.

			regards, tom lane



view thread (68+ messages)  latest in thread

Message-ID: <22702.1224087183@sss.pgh.pa.us>
Permalink:  ../22702.1224087183@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/22702.1224087183@sss.pgh.pa.us

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: tgl@sss.pgh.pa.us, gsmith@gregsmith.com, stark@enterprisedb.com, murphy@genome.chop.edu, pgsql-general@postgresql.org
  Subject: Re: Drupal and PostgreSQL - performance issues?
  In-Reply-To: <22702.1224087183@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox