Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UovLZ-0007OH-RD for pgsql-sql@arkaria.postgresql.org; Tue, 18 Jun 2013 12:49:18 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1UovLZ-0006E1-A0 for pgsql-sql@arkaria.postgresql.org; Tue, 18 Jun 2013 12:49:17 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UovLX-0006C6-Gx for pgsql-sql@postgresql.org; Tue, 18 Jun 2013 12:49:15 +0000 Received: from sam.nabble.com ([216.139.236.26]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UovLV-0006sH-5y for pgsql-sql@postgresql.org; Tue, 18 Jun 2013 12:49:14 +0000 Received: from [192.168.236.26] (helo=sam.nabble.com) by sam.nabble.com with esmtp (Exim 4.72) (envelope-from ) id 1UovLU-0003xH-B7 for pgsql-sql@postgresql.org; Tue, 18 Jun 2013 05:49:12 -0700 Date: Tue, 18 Jun 2013 05:49:12 -0700 (PDT) From: rawi To: pgsql-sql@postgresql.org Message-ID: <1371559752325-5759645.post@n5.nabble.com> In-Reply-To: <1371136856484-5759045.post@n5.nabble.com> References: <1371123556877-5759021.post@n5.nabble.com> <22495.1371135398@sss.pgh.pa.us> <1371136856484-5759045.post@n5.nabble.com> Subject: Re: Index Usage and Running Times by FullTextSearch with prefix matching MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: 1.9 (+) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-sql Precedence: bulk Sender: pgsql-sql-owner@postgresql.org rawi wrote > > Tom Lane-2 wrote >> FWIW, I get fairly decent performance for cases like this in HEAD >> (at least with a GIN index; GIST seems much less able to do well with >> short prefixes). What PG version are you testing? > Thank you Tom, > > I'm testing on PG 9.1 on UbuntuServer 12.10, 64bit > > I'll update to 9.2 the next days and try again. > > Kind Regards > Rawi Just tested with 9.2: pretty much the same -- View this message in context: http://postgresql.1045698.n5.nabble.com/Index-Usage-and-Running-Times-by-FullTextSearch-with-prefix-matching-tp5759021p5759645.html Sent from the PostgreSQL - sql mailing list archive at Nabble.com. -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql