| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
| Cc: | Ondřej Bouda <obouda(at)email(dot)cz>, Ondřej Bouda <bouda(at)edookit(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: backend crash on DELETE, reproducible locally |
| Date: | 2018-11-06 20:14:08 |
| Message-ID: | 333.1541535248@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> writes:
> What indexes are there in this table? Indexes on expressions are
> particularly suspect.
I had not looked at the "projection index" code before, and now that
I have, I am desperately unhappy with it. It's seriously buggy,
badly underdocumented, unbelievably inefficient, and it looks like
it creates a whole new set of reasons for unwanted recursion inside
the relcache. The relcache has got NO business calling cost_qual_eval,
for example.
Having said that, I'm not real sure how it ends up with this crash.
It looks like ProjIndexIsUnchanged is getting the wrong value for
the index column's typbyval, but how could that be?
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2018-11-06 20:17:05 | Re: backend crash on DELETE, reproducible locally |
| Previous Message | Ondřej Bouda | 2018-11-06 19:54:31 | Re: backend crash on DELETE, reproducible locally |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2018-11-06 20:17:05 | Re: backend crash on DELETE, reproducible locally |
| Previous Message | Andrew Gierth | 2018-11-06 20:05:26 | Re: Optimizing nested ConvertRowtypeExpr execution |