Tsearch Index Size and GiST vs. GIN

From: Richard Whidden <richard(at)armchair(dot)mb(dot)ca>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Tsearch Index Size and GiST vs. GIN
Date: 2006-11-06 19:14:20
Message-ID: cone.1162840460.217543.21329.1000@oldbob
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrus 2006-11-06 19:21:54 How to force strong passwords
Previous Message Tom Lane 2006-11-06 19:08:15 Re: timezone difference in timestamp?

Browse pgsql-hackers by date

  From Date Subject
Next Message Matt Miller 2006-11-06 19:15:14 Re: cvs 'initdb' -- "vacuuming database template1 ... FATAL:
Previous Message Simon Riggs 2006-11-06 19:12:32 Re: adminpack and pg_catalog