| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
| Cc: | ITAGAKI Takahiro <itagaki(dot)takahiro(at)lab(dot)ntt(dot)co(dot)jp>, postgres(at)cybertec(dot)at, pgsql-patches(at)postgresql(dot)org, Koichi Suzuki <koichi(at)intellilink(dot)co(dot)jp>, Satoshi Nagayasu <nagayasus(at)nttdata(dot)co(dot)jp>, ikubo(at)intellilink(dot)co(dot)jp, yasunaga <yasunaga(dot)hisato(at)soft(dot)fujitsu(dot)com>, Bruce Momjian <root(at)candle(dot)pha(dot)pa(dot)us>, Jan Wieck <JanWieck(at)Yahoo(dot)com>, sakata(dot)tetsuo(at)lab(dot)ntt(dot)co(dot)jp, "T(dot)Honishi" <honishi(dot)takashi(at)lab(dot)ntt(dot)co(dot)jp> |
| Subject: | Re: A couple of p.tches for PostgreSQL 64bit support |
| Date: | 2005-07-08 03:03:40 |
| Message-ID: | 7162.1120791820@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> writes:
> On Fri, Jul 08, 2005 at 09:38:07AM +0900, ITAGAKI Takahiro wrote:
>> Avoiding overheads, can XIDs/CIDs be different bit length? For example,
>> can XIDs/CIDs be changed to 48/16-bit or 40/24-bit?
> Not unless you change the definition of HeapTupleFields
> (src/include/access/htup.h). Alignment concerns would probably bite you
> if you changed it, anyway.
I don't think we could feasibly reduce the width of CID anyway; we've
already seen a few complaints of people overrunning 2^32 commands per
transaction, and surely this is a bigger rather than a lesser concern
if you are thinking of large databases.
It probably would be possible to keep CID at 32 bits and lay out the
HeapTupleHeader so that you only pay for three, not four, 64-bit
fields ... but that's still twelve bytes added per tuple.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-07-08 03:18:51 | Re: Must be owner to truncate? |
| Previous Message | Christopher Kings-Lynne | 2005-07-08 02:49:42 | Hmmm 8.1 pg_dumpall cannot dump older db's? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | jtv | 2005-07-08 03:33:53 | Re: patch: garbage error strings in libpq |
| Previous Message | Alvaro Herrera | 2005-07-08 02:37:04 | Re: A couple of p.tches for PostgreSQL 64bit support |