On 11/3/15 8:34 PM, Jeff Janes wrote:
> I currently have a table with one column which has a median width of
> 500 bytes, a 90th percentile of 650 bytes, and makes up 75% of the
> table's size, and the column is rarely used, while the table itself is
> frequently seq scanned. I'd very much like to drive that column out
> of main and into toast. I think target_tuple_size would let me do
> that.
+1 on having a way to induce that behavior, as I've faced the same thing
in the past.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com