Re: Tsearch2 Initial Search Speed

From: Alan Hodgson <ahodgson(at)simkin(dot)ca>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Tsearch2 Initial Search Speed
Date: 2008-06-17 15:55:21
Message-ID: 200806170855.21575@hal.medialogik.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tuesday 17 June 2008, Howard Cole <howardnews(at)selestial(dot)com> wrote:
> This misses out the random access of the email table, turning my 27
> second query into 6 seconds.

It took less time because it retrieved a lot less data - it still has to
look at the table.

--
Alan

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Alan Hodgson 2008-06-17 15:56:32 Re: Tsearch2 Initial Search Speed
Previous Message Scott Marlowe 2008-06-17 15:42:34 Re: Which hardware ?