Re: Bug #514: Backend crashes periodically - Mailing list pgsql-bugs

Warren Volz <wrv@po.cwru.edu> writes:
> p debug_query_string output:

> $1 = 0x820caa0 "DELETE FROM session WHERE session_key =
> 'bRUjmnqcb5prUNRE.Bb0sq+fZB69dkdVlCAKNBsb'"

BTW, do you have rules or triggers on that table?  The backtrace shows
the system executing a nestloop join, which implies at least a two-table
query, which says that there's more going on than meets the eye here.
It would be useful to see the full schema for this table and any related
tables, as well as an EXPLAIN VERBOSE for the above query.

            regards, tom lane