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 relpages (8k)
8.2 FF100 = 95049

GIN
---
FF100 = 197702


Richard Whidden

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to