Unix Technical Forum

A couple of patches for PostgreSQL 64bit support

This is a discussion on A couple of patches for PostgreSQL 64bit support within the pgsql Hackers forums, part of the PostgreSQL category; --> Hi, all, I have posted a couple of patches with regard to 64bit environment support to PATCHES ml. It ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Hackers

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-11-2008, 04:46 AM
Koichi Suzuki
 
Posts: n/a
Default A couple of patches for PostgreSQL 64bit support

Hi, all,

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.

--
-------------------------------------------
Koichi Suzuki
Open Source Engineeering Departmeent,
NTT DATA Intellilink Corporation
Phone: +81-3-5566-9628 WWW: http://www.intellilink.co.jp
------------------------------------------

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-11-2008, 04:46 AM
Josh Berkus
 
Posts: n/a
Default Re: A couple of patches for PostgreSQL 64bit support

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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 02:46 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com