From: | Koichi Suzuki <koichi(at)intellilink(dot)co(dot)jp> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-patches(at)postgresql(dot)org, 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 patches for PostgreSQL 64bit support |
Date: | 2005-07-08 00:36:10 |
Message-ID: | 42CDCA7A.2030607@intellilink.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
I have some experimeltal data about this extension. I will gather it
and post hopefully this weekend.
Tom Lane wrote:
> Koichi Suzuki <koichi(at)intellilink(dot)co(dot)jp> writes:
>
>>Here're a couple of patches for PostgreSQL 64bit support. There're just
>>two extension to 64bit, size of shared memory and transaction ID.
>
>
> I asked originally for some experimental evidence showing any value
> in having more than 2Gb of shared buffers. In the absence of any
> convincing demonstration, I'm not very inclined to worry about whether
> we can handle wider-than-int shared memory size.
>
> As for the XID change, I don't think this patch accurately reflects the
> size of the impact. There are a lot of things that in practice need to
> be the same size as XID (CID, most obviously, but I suspect also OID).
> And again, some demonstration of the performance impact would be
> appropriate. Here, not only do you have to prove that widening XID
> isn't a big performance hit in itself, but you also have to convince
> us that it's a win compared to the existing approach of vacuuming at
> least every billion transactions.
>
> regards, tom lane
>
--
-------------------------------------------
Koichi Suzuki
Open Source Engineeering Departmeent,
NTT DATA Intellilink Corporation
Phone: +81-3-5566-9628 WWW: http://www.intellilink.co.jp
------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | ITAGAKI Takahiro | 2005-07-08 00:38:07 | Re: A couple of patches for PostgreSQL 64bit support |
Previous Message | David Fetter | 2005-07-08 00:22:52 | Re: SQL99 - Nested Tables |
From | Date | Subject | |
---|---|---|---|
Next Message | ITAGAKI Takahiro | 2005-07-08 00:38:07 | Re: A couple of patches for PostgreSQL 64bit support |
Previous Message | Tom Lane | 2005-07-07 20:45:59 | Re: Dependencies on shared objects |