Re: Postgresq 8,1 hangs when running function

On 8/21/06 5:38 AM, "ben sewell" <mosherben(at)gmail(dot)com> wrote:

> Hi guys,
> I'm running postgresql 8.1 on a P4 3.0GHz,480 MB RAM, 160GB SCSI hard drive
> on Windows XP. Postgres has been crashing when I have tried testing my
> reports function, which i leads me to believe it is something in the
> function because doing normal select statements works fine. Can anyone check
> my code before I ask my boss if I could restart the server, as a restart
> means 20 mins work lost for employees? Just for reference, tblnewbusiness
> containts just under 8,000 records,

Hi, Ben. What do you mean when you say postgres has been "crashing"?

As for "restarting" the server, you can simply do a restart of postgres,
which should mean just a second or so of downtime. You don't need to
physically reboot the machine.

As a more important point, if you have employees using the database that you
are working on and you are feeling like you need to restart the server,
etc., you probably shouldn't be working on that machine. Instead, buy a
$700 laptop (or a $350 PC) and install postgres. Then, dump the database
from the production machine and load it into your "test" machine.

Sean