From: Teodor Sigaev <teodor@sigaev.ru>
To: Patches <pgsql-patches@postgresql.org>
Subject: Re: GIN improvements
Date: Tue, 17 Jun 2008 22:25:46 +0400
Message-ID: <485801AA.1000105@sigaev.ru> (raw)
In-Reply-To: <483FD205.4090904@sigaev.ru>
References: <483FD205.4090904@sigaev.ru>
> 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@sigaev.ru
WWW: http://www.sigaev.ru/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-patches@postgresql.org
Cc: teodor@sigaev.ru
Subject: Re: GIN improvements
In-Reply-To: <485801AA.1000105@sigaev.ru>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox