Re: Increasing RAM for more than 4 Gb. using postgresql

Поиск
Список
Период
Сортировка
От amrit@health2.moph.go.th
Тема Re: Increasing RAM for more than 4 Gb. using postgresql
Дата
Msg-id 1105541313.41e538c110c38@webmail.moph.go.th
обсуждение исходный текст
Ответ на Re: Increasing RAM for more than 4 Gb. using postgresql  (Gavin Sherry <swm@alcove.com.au>)
Ответы Re: Increasing RAM for more than 4 Gb. using postgresql  (Martin Tedjawardhana <bitboxx@gmail.com>)
Список pgsql-performance
> 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

В списке pgsql-performance по дате отправления:

Предыдущее
От: Gavin Sherry
Дата:
Сообщение: Re: Increasing RAM for more than 4 Gb. using postgresql
Следующее
От: Martin Tedjawardhana
Дата:
Сообщение: Re: Increasing RAM for more than 4 Gb. using postgresql