Horton

Re: [PATCHES] Multi-column GIN

Teodor Sigaev <teodor@sigaev.ru>

View thread View on postgr.es
From: Teodor Sigaev <teodor@sigaev.ru>
To: Heikki Linnakangas <heikki@enterprisedb.com>
Cc: Patches <pgsql-patches@postgresql.org>, Pgsql Hackers <pgsql-hackers@postgresql.org>
Date: 2008-07-04T08:41:26Z
Lists: pgsql-hackers 
 > What's the benefit of a multi-column GIN index over multiple
 > single-column GIN indexes?

Page 12 from presentation on PgCon 
(http://www.sigaev.ru/gin/fastinsert_and_multicolumn_GIN.pdf):

Multicolumn index vs.  2 single column indexes

Size:    539 Mb        538 Mb
Speed:   *1.885* ms    4.994 ms
Index:   ~340 s        ~200 s
Insert:  72 s/10000    66 s/10000



-- 
Teodor Sigaev                                   E-mail: teodor@sigaev.ru
                                                    WWW: http://www.sigaev.ru/