Re: Tsearch2 Initial Search Speed

From: Howard Cole <howardnews(at)selestial(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Tsearch2 Initial Search Speed
Date: 2008-06-19 09:03:37
Message-ID: 485A20E9.7090500@selestial.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Kevin Grittner 2008-06-19 13:46:26 Re: An "obvious" index not being used
Previous Message Albe Laurenz 2008-06-19 07:13:42 Re: WAL DUDAS