Re: A couple of patches for PostgreSQL 64bit support

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
------------------------------------------

In response to

Responses

Browse pgsql-hackers by date

  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

Browse pgsql-patches by date

  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