SEO

Hello
We have this one app "pcmiler" that ties directly into our backend of our application and will not run in an 64bit enviroment. We had to get ALK to fix some bugs in there code and that is what all the reboots were about mentioned earlier. Put it this way pcmiler was going places in memory it didn't need to go. They did correct the problem.

jallgood@the-allgoods.net writes:
> This is interesting. We are running a 32bit kernel.

On an Opteron? Why in the world are you doing that?

> The output from free -l -m. I believe the High and Low are like
> watermarks for lack of another word.

Uh, no, you are dead wrong. In a 32-bit machine low memory is the first
physical GB or so, and high memory is the rest, and there are certain
things that have to be in low memory because the hardware won't cope
otherwise. Thus, you can run out of lowmem even when there's scads of
free memory in highmem.

If you've got more than about a GB of physical RAM you need to be
running a 64-bit kernel; otherwise you're wasting your hardware.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

jallgood@the-allgoods.net writes:
> We have this one app "pcmiler" that ties directly into our backend
> of our application and will not run in an 64bit enviroment.

Hmmm ... we have heard of pcmiler before on these lists, and there has
never been anything good said about it. Do a bit of archive searching,
and then consider if you can't find something else.

I'm not totally clear on what pcmiler really does, but perhaps there's
some overlap with PostGIS? Not that PostGIS has no bugs, but at least
it's open-source code and you can hope to get useful commentary from
people who can look at the source. Right at the moment I think you are
stuck trying to get support from pcmiler's authors, because no one else
in the world knows everything that's happening in your system or can fix
it.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Hello All

Yeap that was us on the pcmiler past issues. This app provides
mileage lookup for our application. Our customers require us to use that
package for mileage lookup. Unfortunately there linux version is not
developed as heavily as the windows version when we started having the
vendor look at the code we discovered that it was compiled under Redhat
8.0. At this point I believe that maybe we don't have an "not enough
memory issue" but maybe a memory bleed. This will definitely require us
to dig a little deeper.

Tom Lane wrote:
> jallgood@the-allgoods.net writes:
>
>> We have this one app "pcmiler" that ties directly into our backend
>> of our application and will not run in an 64bit enviroment.
>>
>
> Hmmm ... we have heard of pcmiler before on these lists, and there has
> never been anything good said about it. Do a bit of archive searching,
> and then consider if you can't find something else.
>
> I'm not totally clear on what pcmiler really does, but perhaps there's
> some overlap with PostGIS? Not that PostGIS has no bugs, but at least
> it's open-source code and you can hope to get useful commentary from
> people who can look at the source. Right at the moment I think you are
> stuck trying to get support from pcmiler's authors, because no one else
> in the world knows everything that's happening in your system or can fix
> it.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>
>

On Wed, 29 Aug 2007, John R Allgood wrote:
> [pcmiler] was compiled under Redhat 8.0.

I thought that you might find virtualization useful. (Run redhat 8.0 as a
guest OS) Sorry for the noise if you already have considered it, but it is
a typical case vmware used to tout as a success story. (Running legacy
software inside a legacy guest OS) My experience was with vmware and I
think it will do the job but then I haven't used others yet.

http://www-128.ibm.com/developerwork...html#resources

My 2pence

Ben K.
Developer
http://benix.tamu.edu

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

On Wed, Aug 29, 2007 at 08:05:00AM -0400, John R Allgood wrote:
> Yeap that was us on the pcmiler past issues. This app provides
> mileage lookup for our application. Our customers require us to use that
> package for mileage lookup.

I don't know anything about pcmiler, but does it have to run on the
same box as the back end? Maybe you could put it somewhere else, and
then you could make your databases work well. Finding a nice 32-bit
Intel box for it oughta be pretty trivial (=="cheap") these days.

A

--
Andrew Sullivan | ajs@crankycanuck.ca
This work was visionary and imaginative, and goes to show that visionary
and imaginative work need not end up well.
--Dennis Ritchie

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

I wish that was the case the linux version has to be installed locally.
If you are running Winders you can connect remotely but we don't want to
do that.

Andrew Sullivan wrote:
> On Wed, Aug 29, 2007 at 08:05:00AM -0400, John R Allgood wrote:
>
>> Yeap that was us on the pcmiler past issues. This app provides
>> mileage lookup for our application. Our customers require us to use that
>> package for mileage lookup.
>>
>
> I don't know anything about pcmiler, but does it have to run on the
> same box as the back end? Maybe you could put it somewhere else, and
> then you could make your databases work well. Finding a nice 32-bit
> Intel box for it oughta be pretty trivial (=="cheap") these days.
>
> A
>
>

> I wish that was the case the linux version has to be installed locally. If

> you are running Winders you can connect remotely but we don't want to do
> that.

Maybe you could use pgpool or something similar to allow it to think it's
connecting locally and still move it off the actual postgresql server?





---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

"Jeff Frost" <jeff@frostconsultingllc.com> writes:
> Maybe you could use pgpool or something similar to allow it to think it's
> connecting locally and still move it off the actual postgresql server?

Actually, I don't see anything very wrong with running a 32-bit database
executable, so long as you don't have ambitions to have more than a GB
or so of shared_buffers. The thing that's not good is a 32-bit kernel.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

On Wed, 29 Aug 2007, John R Allgood wrote:

> I wish that was the case the linux version has to be installed locally.

I'm not an expert but I guess "local" may be a bit different in
virtualization.

If "local" requirement is from license or security issues, there are ways
to completely hide the guest from outside networks (provide it only with a
host-to-guest (virtual) network) and it may qualify for local, looking
from the outside.

If it is from technical requirement and means non-tcp/ip, I guess there
may be programmatic solutions possible between host and guest.
(http://pubs.vmware.com/vmci-sdk/VMCI_intro.html)

Just thought it might be worth exploring.

HTH.


Regards,

Ben K.
Developer
http://benix.tamu.edu

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate

can it possiable to uses Postgresql in windows. From where i will verions
for that





>From: Ben Kim <bkim@tamu.edu>
>To: John R Allgood <jallgood@the-allgoods.net>
>CC: pgsql-admin@postgresql.org
>Subject: Re: [ADMIN] How to monitor resources on Linux.
>Date: Fri, 31 Aug 2007 08:17:12 -0500 (CDT)
>
>On Wed, 29 Aug 2007, John R Allgood wrote:
>
>>I wish that was the case the linux version has to be installed locally.
>
>I'm not an expert but I guess "local" may be a bit different in
>virtualization.
>
>If "local" requirement is from license or security issues, there are ways
>to completely hide the guest from outside networks (provide it only with a
>host-to-guest (virtual) network) and it may qualify for local, looking
>from the outside.
>
>If it is from technical requirement and means non-tcp/ip, I guess there may
>be programmatic solutions possible between host and guest.
>(http://pubs.vmware.com/vmci-sdk/VMCI_intro.html)
>
>Just thought it might be worth exploring.
>
>HTH.
>
>
>Regards,
>
>Ben K.
>Developer
>http://benix.tamu.edu
>
>---------------------------(end of broadcast)---------------------------
>TIP 7: You can help support the PostgreSQL project by donating at
>
> http://www.postgresql.org/about/donate

__________________________________________________ _______________
Real Estate classifieds on MSN - for free.www.yello.in
http://www.yello.in/home.php?utm_sou...m_campaign=jun


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend