Re: [HACKERS] Tsearch Index Size and GiST vs. GIN

2006-11-08 Thread Teodor Sigaev
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

[HACKERS] Tsearch Index Size and GiST vs. GIN

2006-11-06 Thread Richard Whidden
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