PG 9.5 2 tables same DDL with diff size

Поиск
Список
Период
Сортировка
От ghiureai
Тема PG 9.5 2 tables same DDL with diff size
Дата
Msg-id 20b07dd9-ab4e-5d48-6fbd-66e1d9161524@nrc-cnrc.gc.ca
обсуждение исходный текст
Ответы RE: PG 9.5 2 tables same DDL with diff size
Список 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



В списке pgsql-performance по дате отправления:

Предыдущее
От: "Kumar, Virendra"
Дата:
Сообщение: RE: Performance of a Query
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: Performance of a Query