On 5/11/23 07:29, Marc Millas wrote: > Hi, > > I keep on investigating on the "death postgres" subject > but open a new thread as I don't know if it's related to my pb. > > I have 2 different clusters, on 2 different machines, one is prod, the > second test. > Same data volumes.
How can they be sharing the same data 'volume'?
roughly: one table is 13080000 lines and the second is 13100000 lines, the data comes from yet another DB.
those 2 tables have no indexes. they are used to build kind of aggregates thru multiple left joins.
Do you mean you are doing dump/restore between them?
no
Postgres version for each cluster is? 14.2
> > On prod if I do > select col_a, count(col_a) from table_a group by col_a order by col_a desc, > I get the numbers of NULL on top. > To get the number of NULL on top on the test db, I have to > select col_a, count(col_a) from table_a group by col_a order by col_a asc. > > so, it looks like there is something different within the b-tree > operator class of varchar (?!?) > between those 2 clusters. > > What can I check to to explain this difference as, to my understanding, > it's not a postgresql.conf parameter. > > thanks > > Marc MILLAS > Senior Architect > +33607850334 > www.mokadb.com <http://www.mokadb.com> >