Re: Tsearch2 Initial Search Speed - Mailing list pgsql-performance

From Alan Hodgson
Subject Re: Tsearch2 Initial Search Speed
Date
Msg-id 200806170855.21575@hal.medialogik.com
Whole thread Raw
In response to Re: Tsearch2 Initial Search Speed  (Howard Cole <howardnews@selestial.com>)
List pgsql-performance
On Tuesday 17 June 2008, Howard Cole <howardnews@selestial.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

pgsql-performance by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Which hardware ?
Next
From: Alan Hodgson
Date:
Subject: Re: Tsearch2 Initial Search Speed