PG 9.5 2 tables same DDL with diff size

From: ghiureai <isabella(dot)ghiurea(at)nrc-cnrc(dot)gc(dot)ca>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: PG 9.5 2 tables same DDL with diff size
Date: 2018-01-09 22:54:07
Message-ID: 20b07dd9-ab4e-5d48-6fbd-66e1d9161524@nrc-cnrc.gc.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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) to match the size in second

PG cluster.

any tips what can make this 2 tables to have diff size except the host (
same OS and PG version 9.5.3)?

Thank you

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Marlowe 2018-01-09 22:59:59 Re: Performance of a Query
Previous Message Kumar, Virendra 2018-01-09 22:25:59 RE: Performance of a Query