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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
