Re: Drupal and PostgreSQL - performance issues?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Drupal and PostgreSQL - performance issues?
Дата
Msg-id 8373.1224040072@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Drupal and PostgreSQL - performance issues?  (Gregory Stark <stark@enterprisedb.com>)
Список 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 по дате отправления:

Предыдущее
От: Gregory Stark
Дата:
Сообщение: Re: Drupal and PostgreSQL - performance issues?
Следующее
От: Artacus
Дата:
Сообщение: Re: Update with a Repeating Sequence