[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[orca-users:09447] Re: 動作が遅くなる



得地@内科医です

八木先生、ありがとうございます。
先生のHPをいつも参考にさせていただいております。
> 
>  /etc/cron.d/postgresの時間設定行がどのようになっているか
> コピペでも書き写しでも結構ですから投稿していただけますか。
> 
以下のようになっております。

# Regular cron jobs for the postgresql package
#
# To ensure proper access rights, 'ident sameuser' access for localhost is
# required in /etc/postgresql/pg_hba.conf.  This is now the default setting for
# the Debian configuration.
#
# If password access for "local" is turned on in /etc/postgresql/pg_hba.conf,
# you must create a file ~postgres/.pgpass containing a line specifying the
# password, as explained in section 1.11 of the PostgreSQL Programmer's Guide
# (package postgresql-doc).
#
# If autovacuum is turned on in /etc/postgresql/postmaster.conf, you need
# to give the -F option to do.maintenance for it to do anything.

# Run VACUUM ANALYSE on all databases every 5 hours
2 0,5,,,20 * * 1-6 postgres	if ! pidof /usr/lib/postgresql/bin/pg_autovacuum >
/dev/null && [ -x /usr/lib/postgresql/bin/do.maintenance ]; then
/usr/lib/postgresql/bin/do.maintenance -a; fi

# On Sunday run a VACUUM FULL ANALYSE as well
# If you run a 24/7 site, you may want to comment out this line and save VACUUM
# FULL for when you think you really need it
# 10 3 * * sun postgres	/usr/bin/test -x /usr/lib/postgresql/bin/do.maintenance
&& /usr/lib/postgresql/bin/do.maintenance -a -f -F