Re: PG 9.5 2 tables same DDL with diff size

[mailto:isabella.ghiu...@nrc-cnrc.gc.ca] Sent: Wednesday, January 10, 2018 10:48 AM To: pgsql-performa...@postgresql.org Subject: RE: PG 9.5 2 tables same DDL with diff size Attention: This email was sent from someone outside of Perceptron. Always exercise caution when opening attachments or clicking

RE: PG 9.5 2 tables same DDL with diff size

-Original Message- From: Isabella Ghiurea [mailto:isabella.ghiu...@nrc-cnrc.gc.ca] Sent: Wednesday, January 10, 2018 10:48 AM To: pgsql-performa...@postgresql.org Subject: RE: PG 9.5 2 tables same DDL with diff size Attention: This email was sent from someone outside of Perceptron

RE: PG 9.5 2 tables same DDL with diff size

I run full vacuum and reindex on largest table (50GB) while there was no server activities so I assume no transaction was holding a lock on table since the full vacuum was able to run, anything where I should consider looking ? -- Sent from: http://www.postgresql-archive.org/PostgreSQL-perform

RE: PG 9.5 2 tables same DDL with diff size

-Original Message- From: ghiureai [mailto:isabella.ghiu...@nrc-cnrc.gc.ca] Sent: Tuesday, January 09, 2018 5:54 PM To: pgsql-performa...@postgresql.org Subject: PG 9.5 2 tables same DDL with diff size HI List I am trying to understand the following : have 2 identical PG cluster on

PG 9.5 2 tables same DDL with diff size

HI List I am trying to understand the following : have 2  identical PG cluster on diff hosts, same postgresql.conf, same db schema :  same tale DDL and row counts but different size ( 14GB diff  ), I run reindex and full vacuum analyze,  but I can not decrease the size of larger table(50GB)