Home > mailing lists

PG 9.5 2 tables same DDL with diff size - Mailing list pgsql-performance

From	ghiureai
Subject	PG 9.5 2 tables same DDL with diff size
Date	January 10, 2018 04:54:07
Msg-id	20b07dd9-ab4e-5d48-6fbd-66e1d9161524@nrc-cnrc.gc.ca Whole thread Raw
Responses	RE: PG 9.5 2 tables same DDL with diff size
List	pgsql-performance

Tree view

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

pgsql-performance by date:

From: "Kumar, Virendra"
Date: 10 January 2018, 04:25:59
Subject: RE: Performance of a Query

From: Scott Marlowe
Date: 10 January 2018, 04:59:59
Subject: Re: Performance of a Query

PG 9.5 2 tables same DDL with diff size - Mailing list pgsql-performance

Previous

Next