On Wed, Jan 12, 2005 at 12:41:38PM -0800, Jeff Davis wrote:

> Except then the two heaps would have to be joined somehow for every
> operation. It makes sense some times to (if you have a very wide table)
> split off the rarely-accessed attributes into a seperate table to be
> joined one-to-one when those attributes are needed. To have the system
> do that automatically would create problems if the attributes that are
> split off are frequently accessed, right?

That mechanism exists right now, and it's called TOAST, dubbed the best
thing since sliced bread.  We even have documentation for it, new as of
our latest RC:

http://developer.postgresql.org/docs/postgres/storage-toast.html

-- 
Alvaro Herrera (<alvherre[(at)]dcc(dot)uchile(dot)cl>)
"El día que dejes de cambiar dejarás de vivir"

In response to

• Re: Much Ado About COUNT(*) at 2005-01-12 20:41:38 from Jeff Davis

Responses

• Re: Much Ado About COUNT(*) at 2005-01-13 02:45:09 from Jeff Davis

pgsql-announce by date

Next:	From: Simon Riggs	Date: 2005-01-12 21:45:51
	Subject: Re: Much Ado About COUNT(*)
Previous:	From: Marek Mosiewicz	Date: 2005-01-12 21:42:06
	Subject: Re: Much Ado About COUNT(*)

pgsql-hackers by date

Next:	From: Tom Lane	Date: 2005-01-12 21:45:11
	Subject: Re: PANIC: right sibling's left-link doesn't match
Previous:	From: Marek Mosiewicz	Date: 2005-01-12 21:42:06
	Subject: Re: Much Ado About COUNT(*)

pgsql-patches by date

Next:	From: Simon Riggs	Date: 2005-01-12 21:45:51
	Subject: Re: Much Ado About COUNT(*)
Previous:	From: Marek Mosiewicz	Date: 2005-01-12 21:42:06
	Subject: Re: Much Ado About COUNT(*)