Bhushan Verma wrote:
>>> Is it a particular one, or does it crash at random?
>
> its crash at random.
Random segfaults easily by application bugs ( memory corruption,
accessing uninitialized memory and dereferencing pointers there, etc )
or hardware issues like bad CPU/CPU cache/memory, overheating, etc.
Are you having issues with any other applications?
If you can afford the load, consider running something quite CPU/memory
intensive for a while - say, a big compile job - and make sure it all
goes smoothly.
It'd also be interesting to know whether a separate PostgreSQL instance
with a fresh database had issues, but that's probably not practical for
you to test.
Most likely it's some kind of corrupt database triggering a subtle bug
somewhere in Pg, anyway...
--
Craig Ringer