From: | "Michaeldba(at)sqlexec(dot)com" <Michaeldba(at)sqlexec(dot)com> |
---|---|
To: | "Jean R(dot) Franco" <jfranco(at)maila(dot)biz> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: pgdump and restore results in different sizes DB |
Date: | 2017-09-04 21:53:10 |
Message-ID: | A6C6F462-71A9-4EE5-AD1C-D7553E7705FF@sqlexec.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Get approximate counts the shortcut way:
Do analyze on all your user tables. Then, do a join with pg_namespace, pg_table(s), and pg_class and spit out the scheme, table name, and number of rows(reltuples).
Not near a computer so forgot if it is pg_table or pg_table.
Sent from my iPad
> On Sep 4, 2017, at 2:15 PM, Jean R. Franco <jfranco(at)maila(dot)biz> wrote:
>
> Thanks for replying,
>
> That takes me to another question:
> - Is there a way to do a count on all the tables at once?
> I can check one by one but that will take me a long time (1596).
>
> I checked the table sizes and they differ very much!
>
> Thanks,
>
> 4 de Setembro de 2017 09:54, Michaeldba(at)sqlexec(dot)com escreveu:
> Do select counts from all your tables in old and new and see if they match.
>
> Sent from my iPad
>
>> On Sep 4, 2017, at 8:36 AM, Jean R. Franco <jfranco(at)maila(dot)biz> wrote:
>> Hi Michael,
>>
>> Thanks for replying,
>>
>> Do you think it would be that big of a size? Over 21G?
>>
>> Thanks,
>>
>> 4 de Setembro de 2017 08:45, "Michael Vitale" <michaeldba(at)sqlexec(dot)com> escreveu:
>> nice benefit of logical dump and restore: bye bye bloat
>>
>>> On September 4, 2017 at 7:35 AM "Jean R. Franco" <jfranco(at)maila(dot)biz> wrote:
>>>
>>> Hello Everyone,
>>>
>>> I'm moving a postgresql server from one server to another, both running versions 9.4.10
>>> It's a single large database and I'm using pgdump to export and restoring on the new server.
>>>
>>> The thing is, on the old server the database size is 81GB, but when I restore on the new server, it decreases to 60GB
>>>
>>> List of databases
>>> Name | Owner | Encoding | Collate | Ctype | Access privileges | Size | Tablespace | Description
>>> ------------+----------+----------+---------+-------+-------------------+-------+------------+-------------
>>> ecidade | postgres | LATIN1 | C | C | | 60 GB | pg_default |
>>>
>>> I'm watching the whole process of restoring it and have no errors.
>>> What could I been doing wrong?
>>>
>>> Thanks,
>
From | Date | Subject | |
---|---|---|---|
Next Message | Achilleas Mantzios | 2017-09-05 07:38:43 | Re: wal_level not changing |
Previous Message | Jean R. Franco | 2017-09-04 18:16:37 | Re: pgdump and restore results in different sizes DB |