| From: | Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com> |
|---|---|
| To: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, Craig Ringer <craig(at)2ndquadrant(dot)com> |
| Cc: | Bill Moran <wmoran(at)potentialtech(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: RFC/WIP: adding new configuration options to TOAST |
| Date: | 2015-11-04 02:54:46 |
| Message-ID: | 56397376.2010408@BlueTreble.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bill Moran | 2015-11-04 02:58:35 | Re: RFC/WIP: adding new configuration options to TOAST |
| Previous Message | Peter Geoghegan | 2015-11-04 02:45:36 | Trivial heap_finish_speculative() error message inaccuracy |