Jukka Holappa wrote:
> I can't easily reproduce this problem but it happens in every few hours in
> my use.
Can you get a core dump and/or a stack trace out of it? I noted that
you're running Gentoo, so recompiling with --enable-debug, if it's not
compiled with it already, shouldn't be a problem :). --enable-cassert
could be helpful as well, though that does have an impact on performace.
Let me know if you need help compiling or getting a core dump or stack
trace with gdb.
> I'm a bit loss about what could cause this. Is there a way to check the
> current database for possible corruption? Regular queries seem to work ok.
Not really. If the query that crashed works when ran after restart, it's
not likely that corruption caused the crash. You could take a backup
with pg_dump; that at least scans through all data, so if something is
corrupted in a table it will complain.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com