Re: My investigations of the postmaster Bus error

[Sorry for copying -patches in my last email, I actually meant to send
it to pgsql-bugs]

Alvaro Herrera wrote:

> I've been playing with the MIPS machine a little and still haven't found
> any _obvious_ cause for the problem. However I suspect that it may be
> related to unaligned memory access, which _I think_ results in a SIGBUS
> on MIPS.

However, this may turn out to be a red herring, because the variables
are allocated in the data segment and not by malloc, so I think it's
pretty hard to believe there's any unaligned acccess. A small program
that simulates what Postgres is doing here is attached, and it doesn't
fail with SIGBUS, which is rather what I'd expect. There may be
something different in the way Postgres does things, but I haven't been
able to find what. Suggestions welcome.

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.