| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
| Cc: | Dávid Suchan <david(dot)suchan(dot)ds(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: pg_upgradecluster transfering only a portion of the data |
| Date: | 2023-02-27 16:36:58 |
| Message-ID: | 372205.1677515818@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> writes:
> On 2/27/23 07:44, Dávid Suchan wrote:
>> After a successful prompt finished, I checked the database and the size
>> went from originally 20gb (in 9.6) to 700~ mb (in 14) while the disk
>> space available shrank by about 2gb meaning that there is still the 20gb
>> of data. I tried the entire process twice (since I had created an AWS
> 1) How did you measure the size of the database clusters?
If it was based on something like "du", perhaps the measurement
was fooled by the fact that most of the data files will be hard-linked
between the old and new clusters.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2023-02-27 16:46:52 | Re: pg_upgradecluster transfering only a portion of the data |
| Previous Message | Adrian Klaver | 2023-02-27 16:14:25 | Re: pg_upgradecluster transfering only a portion of the data |