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
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@sqlexec.com escreveu:
Do select counts from all your tables in old and new and see if they match.
Sent from my iPad
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@sqlexec.com> escreveu:
nice benefit of logical dump and restore: bye bye bloat
On September 4, 2017 at 7:35 AM "Jean R. Franco" <jfranco@maila.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,