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

From Howard Cole
Subject Re: Tsearch2 Initial Search Speed
Date
Msg-id 485A20E9.7090500@selestial.com
Whole thread Raw
In response to Re: Tsearch2 Initial Search Speed  (Matthew Wakeling <matthew@flymine.org>)
List pgsql-performance
> Good idea. Note that Postgres is already doing this to some extent
> with TOAST - read
> http://www.postgresql.org/docs/8.3/interactive/storage-toast.html -
> unfortunately, there doesn't seem to be an option to always move
> particular columns out to TOAST. Your idea will produce an even
> smaller table. However, are email_ids all that you want from the query?
>
> Matthew
>
As you point out - I will need more then the email_ids in the query, but
if I remove just the content, to, cc fields then the size of the table
should shrink dramatically. Just remains to be seen if the TOAST has
already done that optimisation for me.

Again. Thanks Matthew - I owe you a beer.

pgsql-performance by date:

Previous
From: "Albe Laurenz"
Date:
Subject: Re: WAL DUDAS
Next
From: "Kevin Grittner"
Date:
Subject: Re: An "obvious" index not being used