Search Postgresql Archives

Re: Solved? Re: 8.2.4 signal 11 with large transaction

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



In response to Bill Moran <wmoran@xxxxxxxxxxxxxxxxxxxxxxx>:

> In response to "Scott Marlowe" <scott.marlowe@xxxxxxxxx>:
[snip]
> I'm starting to wonder if the OS could be sending the sig 11?
> 
> ... time warp ...
> 
> Yup, that was it.  The OS was limiting the amount of memory a single
> process could use via kern.maxdsiz (FreeBSD).  This was evident with
> ulimit -d.
> 
> So, the fact remains that PG 8.1 returns an out of memory error when
> it hits this, and PG 8.2 coredumps.  Is the 8.2 behaviour expected/
> planned?  The out of memory error I would expect, the coredump I
> would not.

It just occurred to me that there's another wildcard in this one.
The 8.1 system I tested was on FreeBSD 5.5, while both 8.2 systems
were running on FreeBSD 6.2.  I wonder if FreeBSD has changed
which signal gets sent on memory exhaustion?

-- 
Bill Moran
Collaborative Fusion Inc.
http://people.collaborativefusion.com/~wmoran/

wmoran@xxxxxxxxxxxxxxxxxxxxxxx
Phone: 412-422-3463x4023


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux