Re: two memory-consuming postgres processes

From: Alexy Khrabrov <deliverable(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: two memory-consuming postgres processes
Date: 2008-05-02 20:35:32
Message-ID: BEC1D8B1-D5D6-4D8D-8E66-2DA8D813FB7F@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Interestingly, after shutting down the server with
shared_buffer=1500MB in the middle of that UPDATE, I see this:

bash-3.2$ /opt/bin/pg_ctl -D /data/pgsql/ stop
waiting for server to shut down....LOG: received smart shutdown request
LOG: autovacuum launcher shutting down
........................................................... failed
pg_ctl: server does not shut down
bash-3.2$ /opt/bin/pg_ctl -D /data/pgsql/ stop
waiting for server to shut
down..........................................................LOG:
shutting down
LOG: database system is shut down
done
server stopped

-- had to do it twice, the box was paging for a minute or two.

Should I do something about the autovacuum e.g. to turn it off
completely? I thought it's not on as all of it was still commented
out in postgresql.conf as shipped, only tweaked a few numbers as
reported before.

Cheers,
Alexy

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Marlowe 2008-05-02 20:40:51 Re: two memory-consuming postgres processes
Previous Message Alexy Khrabrov 2008-05-02 20:28:42 Re: two memory-consuming postgres processes