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

From Howard Cole
Subject Re: Tsearch2 Initial Search Speed
Date
Msg-id 4857BBF7.7070909@selestial.com
Whole thread Raw
In response to Re: Tsearch2 Initial Search Speed  (Matthew Wakeling <matthew@flymine.org>)
List pgsql-performance
> Actually, the index returns page numbers in the table on disc which
> may contain one or more rows that are relevant. Postgres has to fetch
> the whole row to find out the email_id and any other information,
> including whether the row is visible in your current transaction
> (concurrency control complicates it all). Just having a page number
> isn't much use to you!
>
> Matthew
>
I learn something new every day.

Thanks Matthew.

pgsql-performance by date:

Previous
From: Matthew Wakeling
Date:
Subject: Re: Migration Articles.. ???
Next
From: "Lionel"
Date:
Subject: Which hardware ?