| From: | Oleg Bartunov <oleg(at)sai(dot)msu(dot)su> |
|---|---|
| To: | Teodor Sigaev <teodor(at)sigaev(dot)ru> |
| Cc: | Heikki Linnakangas <heikki(at)enterprisedb(dot)com>, Patches <pgsql-patches(at)postgresql(dot)org>, Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: [PATCHES] Multi-column GIN |
| Date: | 2008-07-04 09:13:17 |
| Message-ID: | Pine.LNX.4.64.0807041312080.11363@sn.sai.msu.ru |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
On Fri, 4 Jul 2008, Teodor Sigaev wrote:
>> 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
Well, another reason is a index feature-completeness
Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru)
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stefan Kaltenbrunner | 2008-07-04 09:31:07 | log_rotation_age integer overflow display quirk |
| Previous Message | Peter Eisentraut | 2008-07-04 08:51:55 | Re: [PATCHES] Explain XML patch v2 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Heikki Linnakangas | 2008-07-04 09:27:55 | Re: Relation forks & FSM rewrite patches |
| Previous Message | Simon Riggs | 2008-07-04 09:05:35 | Re: variadic function support |