Re: Corruption or wrong results with 14.10?
| От | Daniel Westermann (DWE) |
|---|---|
| Тема | Re: Corruption or wrong results with 14.10? |
| Дата | |
| Msg-id | GV0P278MB04190AD18660D3E3739ACD02D2B9A@GV0P278MB0419.CHEP278.PROD.OUTLOOK.COM обсуждение исходный текст |
| Ответ на | Corruption or wrong results with 14.10? ("Daniel Westermann (DWE)" <daniel.westermann@dbi-services.com>) |
| Ответы |
Re: Corruption or wrong results with 14.10?
|
| Список | pgsql-general |
>smrdbprod=# select count(*) from smrr_mgr.formula where crart_id = 21507180000 and chemin = '@';
> count
>-------
> 1
>(1 row)
>
>smrdbprod=# select crart_id, chemin, count(*) from smrr_mgr.formula group by crart_id, chemin having count(*) > 1;
> crart_id | chemin | count
>----------+--------+-------
>(0 rows)
> count
>-------
> 1
>(1 row)
>
>smrdbprod=# select crart_id, chemin, count(*) from smrr_mgr.formula group by crart_id, chemin having count(*) > 1;
> crart_id | chemin | count
>----------+--------+-------
>(0 rows)
Small update:
smrdbprod=# set enable_indexscan to off;
SET
smrdbprod=# select crart_id, chemin, count(*) from smrr_mgr.formula group by crart_id, chemin having count(*) > 1;
crart_id | chemin | count
-------------+--------+-------
35054630000 | @ | 2
4737310000 | @ | 2
10632380000 | @ | 2
14680880000 | @ | 2
4627230000 | @ | 2
10993780000 | @ | 2
....
I think I know what I have to do.
В списке pgsql-general по дате отправления: