Skip site navigation (1) Skip section navigation (2)

Re: GIN improvements

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 (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-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/

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2008-06-17 18:31:03
Subject: Re: Reducing overhead for repeat de-TOASTing
Previous:From: Teodor SigaevDate: 2008-06-17 18:08:46
Subject: Re: Reducing overhead for repeat de-TOASTing

pgsql-patches by date

Next:From: Tom LaneDate: 2008-06-17 18:36:18
Subject: Re: GIN improvements
Previous:From: Bruce MomjianDate: 2008-06-17 16:10:35
Subject: Re: Simplify formatting.c

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group