Re: pg_upgradecluster transfering only a portion of the data - Mailing list pgsql-general

From Adrian Klaver
Subject Re: pg_upgradecluster transfering only a portion of the data
Date
Msg-id 2cc57fe7-daa8-5312-078f-3e7c0adb7606@aklaver.com
Whole thread Raw
In response to pg_upgradecluster transfering only a portion of the data  (Dávid Suchan <david.suchan.ds@gmail.com>)
Responses Re: pg_upgradecluster transfering only a portion of the data  (Dávid Suchan <david.suchan.ds@gmail.com>)
Re: pg_upgradecluster transfering only a portion of the data  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
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.klaver@aklaver.com




pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: pg_upgradecluster transfering only a portion of the data
Next
From: Dávid Suchan
Date:
Subject: Re: pg_upgradecluster transfering only a portion of the data