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.
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
