Re: [HACKERS] LONG

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: wieck(at)debis(dot)com (Jan Wieck)
Cc: peter_e(at)gmx(dot)net, pgman(at)candle(dot)pha(dot)pa(dot)us, pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] LONG
Date: 1999-12-11 18:32:46
Message-ID: 24177.944937166@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

wieck(at)debis(dot)com (Jan Wieck) writes:
> The rare cases, where someone really needs larger tuples and
> not beeing able to use the proposed LONG data type can be
> tackled by increasing BLKSIZE for this specific installation.

This would be a more convincing argument if we supported BLCKSZ
greater than 32K, but we don't.

I think we've speculated about having a compilation flag that gets
thrown to change page offsets from shorts to longs, thereby allowing
larger page sizes. But as Bruce was just pointing out, all of the
code depends in a fundamental way on the assumption that writing a
page is an atomic action. The larger the page size, the more likely
that you'll see broken tables caused by partial page writes. So
allowing BLCKSZ large enough to accomodate any tuple wouldn't be a
very good answer.

I think the proposed LONG type is a hack, and I'd rather see us solve
the problem correctly. ISTM that allowing a tuple to be divided into
"primary" and "continuation" tuples, all stored in the same relation
file, would be a much more general answer and not significantly harder
to implement than a LONG datatype as Jan is describing it.

regards, tom lane

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 1999-12-11 18:52:11 Re: [HACKERS] Last thoughts about LONG
Previous Message Jan Wieck 1999-12-11 18:29:59 Re: [HACKERS] Last thoughts about LONG