Horton
Menu

Re: Corruption or wrong results with 14.10?

Daniel Westermann (DWE) <daniel.westermann@dbi-services.com>

View thread
From: "Daniel Westermann (DWE)" <daniel.westermann@dbi-services.com>
To: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Date: 2023-11-23T13:29:34Z
Lists: 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)

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.