postgresql 8.2 rc1 - crash

["hubert depesz lubaczewski" <depesz(at)gmail(dot)com>]

hi,
i have been testing 8.2 rc1, while i got this problem.

base data:
linux, 32bit, kernel: 2.6.18.3; debian
postgresql version:
PostgreSQL 8.2rc1 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 
3.3.5 (Debian 1:3.3.5-13)
problematic table is over 2gigabytes in size, and has several indices - one of them is gin-index.

problem:
when i issue vacuum full verbose analyze it works, but then crashes with signal 11.
always in the same situation.

i was not able to check what is the reason.
i did:
recompile with debug, set ulimit -c unlimited, and rerun the query.
it crashed.
i bundled:
1. logs
2. core file
3. config of postgresql
4. saved output of vacuum
all of this can be fetched from: http://depesz.com/various/crash.data.tar.bz2
unfortunatelly i'm not c programmer, so i dont know gdb, but i hope you will be ab le to make any sense out of it.

the bz2 file is > 20mb in size.

any help? is it hardware problem? or a missed bug in code?

if i can provide you with more information - please tell me what i should tell you.

depesz

-- 
http://www.depesz.com/ - nowy, lepszy depesz