On 5/11/23 08:00, Marc Millas wrote: > > On Thu, May 11, 2023 at 4:43 PM Adrian Klaver <adrian.klaver@aklaver.com > <mailto:adrian.klaver@aklaver.com>> wrote: > > 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
So how is the data getting from the third database to the prod and test clusters?
For the machines hosting the third db, the prod and test clusters what are?:
should I understand that you suggest that the way the data is inserted Do change the behaviour of the ORDER BY clause ??
OS
OS version
locale
> > > Postgres version for each cluster is? > 14.2
FYI, 14.8 has just been released so the clusters are behind by 6 bug fix releases. Sadly.. I know.