Postgres Pro
Downloads
Home   >   mailing lists

Re: [PATCHES] Multi-column GIN - Mailing list pgsql-hackers

From Teodor Sigaev
Subject Re: [PATCHES] Multi-column GIN
Date
Msg-id 486DE236.7010500@sigaev.ru
Whole thread Raw
In response to Multi-column GIN  ("Heikki Linnakangas" <heikki@enterprisedb.com>)
Responses Re: [PATCHES] Multi-column GIN  (Oleg Bartunov <oleg@sai.msu.su>)
List pgsql-hackers
Tree view 
 > 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/

pgsql-hackers by date:

Previous
From: "Heikki Linnakangas"
Date:
Subject: Multi-column GIN
Next
From: Martijn van Oosterhout
Date:
Subject: Re: A Windows x64 port of PostgreSQL