From: amrit@health2.moph.go.th
To: Gavin Sherry <swm@alcove.com.au>
Cc: PGsql-performance <pgsql-performance@postgresql.org>
Subject: Re: Increasing RAM for more than 4 Gb. using postgresql
Date: Wed, 12 Jan 2005 21:48:33 +0700
Message-ID: <1105541313.41e538c110c38@webmail.moph.go.th> (raw)
In-Reply-To: <Pine.LNX.4.58.0501122343160.6728@linuxworld.com.au>
References: <1105501768.41e49e484d779@webmail.moph.go.th>
<Pine.LNX.4.58.0501122343160.6728@linuxworld.com.au>
> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: amrit@health2.moph.go.th, swm@alcove.com.au
Subject: Re: Increasing RAM for more than 4 Gb. using postgresql
In-Reply-To: <1105541313.41e538c110c38@webmail.moph.go.th>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox