pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Joshua D. Drake <jd@commandprompt.com>
To: Hervé Piedvache <herve@elma.fr>
Cc: Michael Fuhr <mike@fuhr.org>
Cc: pgsql-performance@postgresql.org
Subject: Re: Tsearch2 really slower than ilike ?
Date: Tue, 16 Nov 2004 08:04:28 -0800
Message-ID: <419A250C.9020300@commandprompt.com> (raw)
In-Reply-To: <200411161648.11519.herve@elma.fr>
References: <200411161555.59144.herve@elma.fr>
	<20041116153256.GA6026@winnie.fuhr.org>
	<200411161648.11519.herve@elma.fr>


>>or more.
>>    
>>
>
>Yes site name ... is company names or web site name ... so not many word in 
>each record ... but I don't understand why more words are more efficient than 
>few words ?? sorry ...
>  
>
Well there are a couple of reasons but the easiest one is index size.
An ILIKE btree index is in general going to be much smaller than a gist 
index.
The smaller the index the faster it is searched.

Sincerely,

Joshua D. Drake



>Regards,
>  
>


-- 
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL

Attachments:

jd.vcf (text/x-vcard, 283B) download begin:vcard fn:Joshua Drake n:Drake;Joshua org:Command Prompt, Inc. adr:;;PO Box 215 ;Cascade Locks;OR;97014;US email;internet:jd@commandprompt.com title:Consultant tel;work:503-667-4564 tel;fax:503-210-0334 x-mozilla-html:FALSE url:http://www.commandprompt.com version:2.1 end:vcard

view thread (16+ messages)  latest in thread

Message-ID: <419A250C.9020300@commandprompt.com>
Permalink:  ../419A250C.9020300@commandprompt.com/
Also on:    postgresql.org/message-id/419A250C.9020300@commandprompt.com

 · 

reply

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-performance@postgresql.org
  Cc: jd@commandprompt.com, herve@elma.fr, mike@fuhr.org
  Subject: Re: Tsearch2 really slower than ilike ?
  In-Reply-To: <419A250C.9020300@commandprompt.com>

* 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