Re: order by

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

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.

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com