On Thu, May 11, 2023 at 5:23 PM Adrian Klaver <adrian.kla...@aklaver.com> wrote:
> On 5/11/23 08:00, Marc Millas wrote: > > > > On Thu, May 11, 2023 at 4:43 PM Adrian Klaver <adrian.kla...@aklaver.com > > <mailto:adrian.kla...@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. > > > -- > Adrian Klaver > adrian.kla...@aklaver.com > >
