Atom D510 supports Intel 64. But I would say it all depends on the mobo chipset as to how much RAM can be used. 32 and 64 bit Windows limitations, or lack thereof, still apply.
It's up to the OS.
Intel Atom D510:
http://ark.intel.com/Product.aspx?id=43098
Only the Intel NM10 chipset supports it:
http://ark.intel.com/chipset.aspx?familyID=46773
But no mention of max memory supported on Intel's site. It's blank.
EDIT: After reading up more on Pineview (Atom D510/NM10 chipset) it seems max support for the chipset is 4GB single channel DDR2 800. Max of 2 DIMMS.
So, like I mentioned, the usage of memory depends on the OS. 32 or 64 bit.
Don't forget, the integrated graphics will still use up some of that system memory, as always.
And it seems the integrated graphics didn't improve. Akin to the specs of Intels GMA 950.
Quote from review at TomsHardware:
http://www.tomshardware.com/reviews/atom-d510-d510mo,2507-3.html
"In other words, you’re getting four pixel pipelines running at 400 MHz with DirectX 9 support via software-based Vertex Shader 3.0 support and hardware Pixel Shader 2.0 support. Video acceleration is limited to MPEG-2 playback, so don’t expect a desktop
based on the Atom D510 or D410 to accommodate Blu-ray movies. This actually turns out to be a bummer, because the US15W core logic already used to drive lower-power Atom-based devices includes licensed PowerVR SGX graphics able to accelerate MPEG-2, VC-1, and AVC in hardware."