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@maila.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!
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?