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
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 |