Re: A couple of patches for PostgreSQL 64bit support

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Koichi Suzuki <koichi(at)intellilink(dot)co(dot)jp>
Cc: pgsql-hackers(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>, Tom Lane <tgl(at)sss(dot)pgh(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-07 16:58:02
Message-ID: 200507070958.02681.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Koichi,

> I have posted a couple of patches with regard to 64bit environment
> support to PATCHES ml. It expands size of shared memory to 64bit space
> and extends XID to 64bit. Please take a look at it.

In case you weren't aware, feature freeze was last Friday. So your patch is
liable to remain in the queue for a while before anyone looks at it.

Incidentally, what about 64-bit support for work_mem and maintenance_work_mem?
64bit shared_mem support isn't that needed *yet* (I've yet to see a server
use more than 500mb of the shared_mem) but being able to allocate 6GB to
index creation would be very useful.

I take it extending the XID to 64bit is intended to postpone the need for
vacuuming even in a high-activity database? Have you tested whether there
are any performance effects?

--
Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Josh Berkus 2005-07-07 16:59:58 Re: Checkpoint cost, looks like it is WAL/CRC
Previous Message Hans-Jürgen Schönig 2005-07-07 16:54:28 Re: A couple of patches for PostgreSQL 64bit support

Browse pgsql-patches by date

  From Date Subject
Next Message Alvaro Herrera 2005-07-07 17:11:21 Re: A couple of p.tches for PostgreSQL 64bit support
Previous Message Hans-Jürgen Schönig 2005-07-07 16:54:28 Re: A couple of patches for PostgreSQL 64bit support