Re: brin regression test intermittent failures
| От | Tom Lane |
|---|---|
| Тема | Re: brin regression test intermittent failures |
| Дата | |
| Msg-id | 13134.1433438099@sss.pgh.pa.us обсуждение исходный текст |
| Ответ на | Re: brin regression test intermittent failures (Tom Lane <tgl@sss.pgh.pa.us>) |
| Ответы |
Re: brin regression test intermittent failures
|
| Список | pgsql-hackers |
I wrote:
> I think it would be a good idea to extend the brinopers table to include
> the number of expected matches, and to complain if that's not what we got,
> rather than simply checking for zero.
Also, further experimentation shows that there are about 30 entries in the
brinopers table that give rise to seqscan plans even when we're commanding
a bitmap scan, presumably because those operators aren't brin-indexable.
They're not the problematic cases, but things like
((charcol)::text > 'A'::text)
Is there a reason to have such things in the table, or is this just a
thinko? Or is it actually a bug that we're getting such plans?
regards, tom lane
В списке pgsql-hackers по дате отправления: