Re: Drupal and PostgreSQL - performance issues? - Mailing list pgsql-general

From Tom Lane
Subject Re: Drupal and PostgreSQL - performance issues?
Date
Msg-id 8373.1224040072@sss.pgh.pa.us
Whole thread Raw
In response to Re: Drupal and PostgreSQL - performance issues?  (Gregory Stark <stark@enterprisedb.com>)
List pgsql-general
Gregory Stark <stark@enterprisedb.com> writes:
> Greg Smith <gsmith@gregsmith.com> writes:
>> DB2 has automatically updated the "shmmax" kernel
>> parameter from "33554432" to the recommended value "268435456".

> This seems like a bogus thing for an application to do though. The Redhat
> people seem happy with the idea but I'm pretty sure it would violate several
> Debian packaging rules.

FWIW, I don't think Red Hat would accept it either.

> ISTM the right way to make it go away is to allocate temporary files and mmap
> them instead of using sysv shared memory.

That's a non-starter unless you can point to a different kernel API that
(a) is as portable as SysV and (b) offers the same amount of assistance
towards preventing multiple postmasters in the same data directory.
See many, many previous discussions in -hackers.

            regards, tom lane

pgsql-general by date:

Previous
From: Gregory Stark
Date:
Subject: Re: Drupal and PostgreSQL - performance issues?
Next
From: Artacus
Date:
Subject: Re: Update with a Repeating Sequence