Tsearch Index Size and GiST vs. GIN - Mailing list pgsql-hackers

From Richard Whidden
Subject Tsearch Index Size and GiST vs. GIN
Date
Msg-id cone.1162840460.217543.21329.1000@oldbob
Whole thread Raw
Responses Re: Tsearch Index Size and GiST vs. GIN  (Teodor Sigaev <teodor@sigaev.ru>)
List 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


pgsql-hackers by date:

Previous
From: "Matt Miller"
Date:
Subject: Re: cvs 'initdb' -- "vacuuming database template1 ... FATAL:
Next
From: "Simon Riggs"
Date:
Subject: Introducing an advanced Frequent Update Optimization