Unix Technical Forum

Re: High end server and storage for a PostgreSQL OLTP system

This is a discussion on Re: High end server and storage for a PostgreSQL OLTP system within the Pgsql Performance forums, part of the PostgreSQL category; --> William Yu wrote: > >>You can get 64-bit Xeons also but it takes hit in the I/O department due ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > Pgsql Performance

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-18-2008, 11:04 AM
Bruce Momjian
 
Posts: n/a
Default Re: High end server and storage for a PostgreSQL OLTP system

William Yu wrote:
> >>You can get 64-bit Xeons also but it takes hit in the I/O department due
> >>to the lack of a hardware I/O MMU which limits DMA transfers to
> >>addresses below 4GB. This has a two-fold impact:
> >>
> >>1) transfering data to >4GB require first a transfer to <4GB and then a
> >>copy to the final destination.
> >>
> >>2) You must allocate real memory 2X the address space of the devices to
> >>act as bounce buffers. This is especially problematic for workstations
> >>because if you put a 512MB Nvidia card in your computer for graphics
> >>work -- you've just lost 1GB of memory. (I dunno how much the typical
> >>SCSI/NIC/etc take up.)


When you say "allocate real memory 2X" are you saying that if you have
16GB of RAM only 8GB is actually usable and the other 8GB is for
bounce buffers, or is it just address space being used up?

--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.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 08:14 PM.


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