Re: A couple of p.tches for PostgreSQL 64bit support
От
Tom Lane
Тема
Re: A couple of p.tches for PostgreSQL 64bit support
Дата
Msg-id
7162.1120791820@sss.pgh.pa.us
Ответ на
Re: A couple of p.tches for PostgreSQL 64bit support (Alvaro Herrera)
Список
Дерево обсуждения
A couple of patches for PostgreSQL 64bit support Koichi Suzuki <koichi@intellilink.co.jp>
Re: A couple of patches for PostgreSQL 64bit support Tom Lane <tgl@sss.pgh.pa.us>
Re: A couple of patches for PostgreSQL 64bit support Koichi Suzuki <koichi@intellilink.co.jp>
A couple of patches for PostgreSQL 64bit support Koichi Suzuki <koichi@intellilink.co.jp>
Re: A couple of patches for PostgreSQL 64bit support Tom Lane <tgl@sss.pgh.pa.us>
Re: A couple of patches for PostgreSQL 64bit support Hans-Jürgen Schönig <postgres@cybertec.at>
Re: A couple of patches for PostgreSQL 64bit support Tom Lane <tgl@sss.pgh.pa.us>
Re: A couple of patches for PostgreSQL 64bit support Hans-Jürgen Schönig <postgres@cybertec.at>
Re: A couple of p.tches for PostgreSQL 64bit support Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: A couple of patches for PostgreSQL 64bit support ITAGAKI Takahiro <itagaki.takahiro@lab.ntt.co.jp>
Re: A couple of p.tches for PostgreSQL 64bit support Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: A couple of p.tches for PostgreSQL 64bit support Tom Lane <tgl@sss.pgh.pa.us>
Re: A couple of p.tches for PostgreSQL 64bit support Satoshi Nagayasu <nagayasus@nttdata.co.jp>
Re: A couple of patches for PostgreSQL 64bit support Koichi Suzuki <koichi@intellilink.co.jp>
Re: A couple of patches for PostgreSQL 64bit support Koichi Suzuki <koichi@intellilink.co.jp>
Re: A couple of patches for PostgreSQL 64bit support Mark Wong <markw@osdl.org>
Re: A couple of patches for PostgreSQL 64bit support Koichi Suzuki <koichi@intellilink.co.jp>
Re: A couple of patches for PostgreSQL 64bit support Koichi Suzuki <koichi@intellilink.co.jp>
Alvaro Herrera 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
В списке pgsql-patches по дате отправления