Re: VACUUM ANALYZE

"Ben-Nes Michael" <miki@canaan.co.il> writes:
> (gdb) bt
> #0  0x4014d8e0 in ?? ()
> #1  0x8123a52 in ?? ()
> #2  0x8123a9f in ?? ()
> #3  0x8123caa in ?? ()
> [ etc ]

Sigh, that's no help at all :-(.  Looks like you are using a postgres
executable that's been stripped of all symbolic information.  Don't
suppose you want to compile from source to make a more debuggable copy?

Actually, maybe it's not quite no help at all.  I'm going to guess from
the numeric values that the core dump is occurring in a system library
(since the top address is so far different from the rest).  Since this
is a vacuum analyze, and since it's on a redhat machine, I'm going to
leap to a conclusion: maybe you are running into the known strcoll()
bug.  Are you running glibc earlier than 2.2.3?  If so, an update to
2.2.3 may fix it.  See the thread at

http://fts.postgresql.org/db/mw/msg.html?mid=1021209

            regards, tom lane