Thread: high cpu usage with postgres on windows XP

high cpu usage with postgres on windows XP

From
a m
Date:
Hello,

I've been trying to install postgres on XP for a
couple days without much luck.

I can get postgres to run, but it is using 95-97% just
running on it's own. As soon as I start postmaster,
the cpu usage jumps all the way up and stays there.

I followed all the install instructions at:
http://www.tishler.net/jason/software/postgresql/postgresql-7.3.4.README

I made sure to include the additional packages in
cygwin listed. I also modified the permissions of the
/usr/bin, /tmp, and /var/log permissions as mentioned.
I added the cygwin/bin to my path as well.

The only thing I can find are the following errors in
the log file:

LOG:  PGSTATBUFF: recvfrom() failed: Resource
temporarily unavailable
LOG:  statistics collector process (pid 3092) exited
with exit code 1
LOG:  PGSTATBUFF: recvfrom() failed: Resource
temporarily unavailable
LOG:  statistics collector process (pid 3184) exited
with exit code 1
...
These lines are repeated indefinitely until I shut
down postmaster (the only thing that changes in the
messages is the pid).

Any ideas or suggestions?

thanks,

am




__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com

Re: high cpu usage with postgres on windows XP

From
Jason Tishler
Date:
am,

On Mon, Sep 08, 2003 at 12:31:04PM -0700, a m wrote:
> The only thing I can find are the following errors in the log file:
>
> LOG:  PGSTATBUFF: recvfrom() failed: Resource
> temporarily unavailable
> LOG:  statistics collector process (pid 3092) exited
> with exit code 1
> LOG:  PGSTATBUFF: recvfrom() failed: Resource
> temporarily unavailable
> LOG:  statistics collector process (pid 3184) exited
> with exit code 1
> ...
> These lines are repeated indefinitely until I shut down postmaster
> (the only thing that changes in the messages is the pid).
>
> Any ideas or suggestions?

Does the following workaround help with your problem too?

    http://cygwin.com/ml/cygwin/2003-07/msg00722.html

Jason

--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D  8784 1AFD E4CC ECF4 8EF6

Re: high cpu usage with postgres on windows XP

From
a m
Date:
Hi Jason,

thanks - I tried that - it doesn't seem to be picking
up the conf file though as it's still writing out the
error messages to the postmaster.log file.

I copied the "sample" conf file to "postgresql.conf",
uncommented out the line and changed it to false. I
tried the same in the .sample version. I even tried
uncommenting out all the lines in the .conf file.

Should the file be in a different directory than
/usr/share/postgresql? or is there some option to get
it to recognize the .conf file? I tried starting and
stopping both ipc-daemon2 as well as postmaster - I
rebooted as well.

thanks


--- Jason Tishler <jason@tishler.net> wrote:
> am,
>
> On Mon, Sep 08, 2003 at 12:31:04PM -0700, a m wrote:
> > The only thing I can find are the following errors
> in the log file:
> >
> > LOG:  PGSTATBUFF: recvfrom() failed: Resource
> > temporarily unavailable
> > LOG:  statistics collector process (pid 3092)
> exited
> > with exit code 1
> > LOG:  PGSTATBUFF: recvfrom() failed: Resource
> > temporarily unavailable
> > LOG:  statistics collector process (pid 3184)
> exited
> > with exit code 1
> > ...
> > These lines are repeated indefinitely until I shut
> down postmaster
> > (the only thing that changes in the messages is
> the pid).
> >
> > Any ideas or suggestions?
>
> Does the following workaround help with your problem
> too?
>
>
> http://cygwin.com/ml/cygwin/2003-07/msg00722.html
>
> Jason
>
> --
> PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc
> or key servers
> Fingerprint: 7A73 1405 7F2B E669 C19D  8784 1AFD
> E4CC ECF4 8EF6


__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com

Re: high cpu usage with postgres on windows XP

From
a m
Date:
ignore the last message - I fixed it.

The problem I was having is that I wasn't able to see
into the /usr/share/postgres/data folder as the
permissions were set to "postgres". I was trying to
use conf files outside that folder.

In case anyone else runs into the same problem, the
fix listed in the link below works - setting
stats_start_collector to false in the following file:
/usr/share/postgresql/data/postgresql.conf. You may
have to login/switch user to the "postgres" user to
access that folder and make the necessary change.

thanks!

--- a m <arte91@yahoo.com> wrote:
> Hi Jason,
>
> thanks - I tried that - it doesn't seem to be
> picking
> up the conf file though as it's still writing out
> the
> error messages to the postmaster.log file.
>
> I copied the "sample" conf file to
> "postgresql.conf",
> uncommented out the line and changed it to false. I
> tried the same in the .sample version. I even tried
> uncommenting out all the lines in the .conf file.
>
> Should the file be in a different directory than
> /usr/share/postgresql? or is there some option to
> get
> it to recognize the .conf file? I tried starting and
> stopping both ipc-daemon2 as well as postmaster - I
> rebooted as well.
>
> thanks
>
>
> --- Jason Tishler <jason@tishler.net> wrote:
> > am,
> >
> > On Mon, Sep 08, 2003 at 12:31:04PM -0700, a m
> wrote:
> > > The only thing I can find are the following
> errors
> > in the log file:
> > >
> > > LOG:  PGSTATBUFF: recvfrom() failed: Resource
> > > temporarily unavailable
> > > LOG:  statistics collector process (pid 3092)
> > exited
> > > with exit code 1
> > > LOG:  PGSTATBUFF: recvfrom() failed: Resource
> > > temporarily unavailable
> > > LOG:  statistics collector process (pid 3184)
> > exited
> > > with exit code 1
> > > ...
> > > These lines are repeated indefinitely until I
> shut
> > down postmaster
> > > (the only thing that changes in the messages is
> > the pid).
> > >
> > > Any ideas or suggestions?
> >
> > Does the following workaround help with your
> problem
> > too?
> >
> >
> > http://cygwin.com/ml/cygwin/2003-07/msg00722.html
> >
> > Jason
> >
> > --
> > PGP/GPG Key:
> http://www.tishler.net/jason/pubkey.asc
> > or key servers
> > Fingerprint: 7A73 1405 7F2B E669 C19D  8784 1AFD
> > E4CC ECF4 8EF6
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! SiteBuilder - Free, easy-to-use web site
> design software
> http://sitebuilder.yahoo.com
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 8: explain analyze is your friend


__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com

Re: high cpu usage with postgres on windows XP

From
Jason Tishler
Date:
On Mon, Sep 08, 2003 at 04:41:40PM -0700, a m wrote:
> In case anyone else runs into the same problem, the fix listed in the
> link below works - setting stats_start_collector to false in the
> following file: /usr/share/postgresql/data/postgresql.conf. You may
> have to login/switch user to the "postgres" user to access that folder
> and make the necessary change.

Now it would be nice if someone figures out why some environments
require this workaround...

> thanks!

You are quite welcome.

Jason

--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D  8784 1AFD E4CC ECF4 8EF6