| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Warren Volz <wrv(at)po(dot)cwru(dot)edu> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: Bug #514: Backend crashes periodically |
| Date: | 2001-11-12 03:53:08 |
| Message-ID: | 737.1005537188@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Warren Volz <wrv(at)po(dot)cwru(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Warren Volz | 2001-11-12 04:20:20 | Re: Bug #514: Backend crashes periodically |
| Previous Message | Tom Lane | 2001-11-12 02:03:03 | Re: [BUGS] 7.2 doc comments |