> There is no problem with free Linux distros handling > 4 GB of memory. The > problem is that 32 hardware must make use of some less than efficient > mechanisms to be able to address the memory. > > So, try 7.4 before the memory upgrade. If you still have performance issues, > try optimising your queries. As I mentioned before, you can join the > #postgresql channel on irc.freenode.net and we can assist.
Yes , of course I must try to upgrade PGsql to 7.4 and may be OS to FC 2-3 too. My server products are intel based [mainboard , CPU ,Case , Power supply ,RAID Network card] dual Xeon 32 bit 3.0 Ghz which I consulted Thai intel supervisor and they told me that increasing the ram for more than 4 Gb. may be possible depending on the OS. I ask the programmer who wrote that huge query and they told me that it was the query generated by Delphi 6.0 component and not written by themselve. Amrit Thailand ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
