> 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?
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 Grittner||Date: 2008-06-19 13:46:26|
|Subject: Re: An "obvious" index not being used|
|Previous:||From: Albe Laurenz||Date: 2008-06-19 07:13:42|
|Subject: Re: WAL DUDAS|