postgresql üzerinde "autovacuum" nedir? ne işe yarar ve kullanılması
gereklimidir? kapatılsa sisteme zarar verir mi?
Oct 1 23:18:54 mail postgres[48212]: [1-1] UYARI: geçersiz ayarlarından
dolayı autovacuum =çalıştırılamadı
Oct 1 23:18:54 mail postgres[48212]: [1-2] =DDPUCU:"stats_start_collector"
ve "stats_row_level" seçeneklerini etkinleşitirin.
[EMAIL PROTECTED]:/www/db/pgsql/data]# egrep autovacuum *
postgresql.conf:autovacuum =3D on
postgresql.conf:#autovacuum =3D off # enable autova=
cuum=20
subprocess?
postgresql.conf:#autovacuum_naptime =3D 1min # time between=20
autovacuum runs
postgresql.conf:#autovacuum_vacuum_threshold =3D 500 # min # of tupl=
e=20
updates before
postgresql.conf:#autovacuum_analyze_threshold =3D 250 # min # of tupl=
e=20
updates before
postgresql.conf:#autovacuum_vacuum_scale_factor =3D 0.2 # fraction of r=
el=20
size before
postgresql.conf:#autovacuum_analyze_scale_factor =3D 0.1 # fraction of r=
el=20
size before
postgresql.conf:#autovacuum_freeze_max_age =3D 200000000 # maximum XID a=
ge=20
before forced vacuum
postgresql.conf:#autovacuum_vacuum_cost_delay =3D -1 # default vacuu=
m=20
cost delay for
postgresql.conf: # autovacuum, -1=20
means use
postgresql.conf:#autovacuum_vacuum_cost_limit =3D -1 # default vacuu=
m=20
cost limit for
postgresql.conf: # autovacuum, -1=20
means use
[EMAIL PROTECTED]:/www/db/pgsql/data]#
---------------------------------------------------------------------
Listeye soru sormadan once lutfen http://ipucu.enderunix.org sitesine bakiniz.
Cikmak icin, e-mail: [EMAIL PROTECTED]
Liste arsivi: http://news.gmane.org/gmane.org.user-groups.bsd.turkey
FreeBSD 6 kitabi cikti! http://www.acikakademi.com/catalog/freebsd6