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

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 (view raw or flat)
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

pgsql-performance by date

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

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