| From: | Teodor Sigaev <teodor(at)sigaev(dot)ru> |
|---|---|
| To: | Heikki Linnakangas <heikki(at)enterprisedb(dot)com> |
| Cc: | 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 08:41:26 |
| Message-ID: | 486DE236.7010500@sigaev.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
> 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(at)sigaev(dot)ru
WWW: http://www.sigaev.ru/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2008-07-04 08:44:25 | Re: WIP: executor_hook for pg_stat_statements |
| Previous Message | Simon Riggs | 2008-07-04 08:37:10 | Re: Sorting writes during checkpoint |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2008-07-04 08:44:25 | Re: WIP: executor_hook for pg_stat_statements |
| Previous Message | Zdenek Kotala | 2008-07-04 08:38:04 | Re: page macros cleanup |