GIST index (polygon, point)

Hi List, I have a short description bellow from Dev team regarding the behaviour of gist index on the polygon column, looking to get some  feedback  from you: " I was expecting the <@(point,polygon) and @>(polygon,point) to be indexable but they are not. see bellow query output , the col

Re: PG 9.5 2 tables same DDL with diff size

Thank you Igor, I was able to eliminate  the 15GB bloating for a 35GB table size  , only after I restart the      Pg server with one single connections and run a full vacuum for table. Isabella On 10/01/18 11:10 AM, Igor Neyman wrote: -Original Message- From: Isabella Ghiurea [mail

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)