"Ed L." <[EMAIL PROTECTED]> writes: >> I wouldn't panic. 99% of the value of a 64-bit box for database work >> is that you can handle more than 4Gb worth of RAM for disk cache. Since >> in Postgres's worldview most of the disk caching is supposed to be done >> by the kernel, it really matters not whether the Postgres executables >> think they are 32-bit or 64-bit. All you need is a 64-bit kernel.
> The HPUX gurus on http://forums1.itrc.hp.com testify that kernel caches > above approximately 600MB are counter-productive to performance. Why? And why would you think that whatever effect is limiting the performance would not also apply to Postgres? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match