Richard Whidden wrote:
Due to popular demand (1 person), I've compared sizes with 90 and 100
fillfactors, along with using the new GIN index.
First, GIN doesn't utilize fillfactor option yet.
Findings were not surprising, except for the GIN indexes, which doubled
in size.
Second, In
Due to popular demand (1 person), I've compared sizes with 90 and 100
fillfactors, along with using the new GIN index.
Findings were not surprising, except for the GIN indexes, which doubled in
size.
After several ALTER/RE INDEXes, here they are:
GiST
8.1 = 94990
8.2 FF90 = 106244