Re: VACUUM FULL out of memory

Поиск
Список
Период
Сортировка
От Sam Mason
Тема Re: VACUUM FULL out of memory
Дата
Msg-id 20080108175328.GB11262@frubble.xen.chris-lamb.co.uk
обсуждение исходный текст
Ответ на Re: VACUUM FULL out of memory  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: VACUUM FULL out of memory  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: VACUUM FULL out of memory  (Andrew Sullivan <ajs@crankycanuck.ca>)
Список pgsql-hackers
On Tue, Jan 08, 2008 at 12:33:34PM -0500, Tom Lane wrote:
> Andrew Sullivan <ajs@crankycanuck.ca> writes:
> > On one system I used many years ago, /bin/sh wasn't what I thought it was,
> > and so the ulimit that I got when logged in was not what the postmaster was
> > starting under.  Took me many days to figure out what was up.
> 
> The only thing I find convincing is to insert "ulimit -a >someplace"
> into the script that starts the postmaster, adjacent to where it does
> so, and then reboot.  There are too many systems on which daemons are
> launched under settings different from what interactive shells use
> (a policy that's often a good one, too).

What about a stored procedure in a language that allows you to do
system(3) calls?

 Sam


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Stefan Kaltenbrunner
Дата:
Сообщение: Re: 8.3.0 release schedule (Was:Re: [BUGS] BUG #3852: Could not create complex aggregate)
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: Proposal - libpq Type System beta-0.8a (was PGparam)