Re: [HACKERS] LONG

Bruce Momjian wrote:

> I disagree.  By moving to another table, we don't have non-standard
> tuples in the main table.  We can create normal tuples in the long*
> table, of identical format, and access them just like normal tuples.
> Having special long tuples in the main table that don't follow the
> format of the other tuples it a certain mess.  The long* tables also
> move the long data out of the main table so it is not accessed in
> sequential scans.  Why keep them in the main table?

    More  ugly  and  complicated (especially for VACUUM) seems to
    me, the we need an index on these  nonstandard  tuples,  that
    doesn't  see  the  standard  ones,  while the regular indices
    ignore the new long tuples. At least  if  we  want  to  delay
    reading of long values until they're explicitly requested.


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#========================================= wieck@debis.com (Jan Wieck) #