From: | Teodor Sigaev <teodor(at)sigaev(dot)ru> |
---|---|
To: | Patches <pgsql-patches(at)postgresql(dot)org> |
Subject: | Re: GIN improvements |
Date: | 2008-06-17 18:25:46 |
Message-ID: | 485801AA.1000105@sigaev.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
> 1) multicolumn GIN
> Unlike other indexes, the performance of search
> doesn't depends on what column of index (first, last, any subset) is
> used in search clause. This property can be used in gincostestimate, but
> I haven't looked on it yet.
After some playing I didn't find any mentions in *costestimate function about
difference of cost estimation between first and any other columns in clauses,
so, IMHO, issue above isn't an issue. :)
So, I didn't see any comments/objections and I intend to commit this patch for
next two days and synchronize 'fast insert into GIN' patch with CVS.
Objections?
--
Teodor Sigaev E-mail: teodor(at)sigaev(dot)ru
WWW: http://www.sigaev.ru/
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-06-17 18:31:03 | Re: Reducing overhead for repeat de-TOASTing |
Previous Message | Teodor Sigaev | 2008-06-17 18:08:46 | Re: Reducing overhead for repeat de-TOASTing |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-06-17 18:36:18 | Re: GIN improvements |
Previous Message | Bruce Momjian | 2008-06-17 16:10:35 | Re: Simplify formatting.c |