Skip site navigation (1) Skip section navigation (2)

Re: Tsearch2 Initial Search Speed

From: Matthew Wakeling <matthew(at)flymine(dot)org>
To: Howard Cole <howardnews(at)selestial(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Tsearch2 Initial Search Speed
Date: 2008-06-17 11:30:48
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
On Tue, 17 Jun 2008, Howard Cole wrote:
> They both appear to do a scan on the email table (Why?).

The indexes don't contain copies of the row data. They only contain 
pointers to the rows in the table. So once the index has been consulted, 
Postgres still needs to look at the table to fetch the actual rows. Of 
course, it only needs to bother looking where the index points, and that 
is the benefit of an index.


I've run DOOM more in the last few days than I have the last few
months.  I just love debugging ;-)  -- Linus Torvalds

In response to


pgsql-performance by date

Next:From: Howard ColeDate: 2008-06-17 11:59:53
Subject: Re: Tsearch2 Initial Search Speed
Previous:From: Howard ColeDate: 2008-06-17 11:23:29
Subject: Re: Tsearch2 Initial Search Speed

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group