From: | Dávid Suchan <david(dot)suchan(dot)ds(at)gmail(dot)com> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: pg_upgradecluster transfering only a portion of the data |
Date: | 2023-02-27 17:18:48 |
Message-ID: | CAHD9QtYATAaZd9SK+iZccG34Zb1fDS+X6pjsNHWRc9Y=RPmwQQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I did not use the -k --link argument while upgrading as that I presume does
not copy the data
Dňa po 27. 2. 2023, 18:10 Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
napísal(a):
> On 2/27/23 09:05, Dávid Suchan wrote:
>
> Please use Reply All
> Ccing list
>
> > My bad,
> > \l+ lists databases and their respective sizes- I used that and also
> > pg_size_pretty(), the result size was the same - before it was 20gb for
> > the biggest db, after it was 700mb.
> > I counted rows before the upgrade in one of the biggest and most
> > important table that I was watching and comparing - before there were
> > hundreds of thousands or millions of rows(not sure about the exact
> > number, just a lot), after the upgrade only like 15, but the first 15
> > rows matched after the upgrade when I checked with select of that table.
> >
> >
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Laurenz Albe | 2023-02-27 17:40:57 | Re: pg_upgradecluster transfering only a portion of the data |
Previous Message | Adrian Klaver | 2023-02-27 17:10:28 | Re: pg_upgradecluster transfering only a portion of the data |