Tom,
I tried to update a table with ~3 million records a set=null,
it takes a hour unfinished. I checked my vmstat, it shown that disk where
the WAL written
was 100% busy, so I think we reach the bottleneck. What else parameters I
can turn?
or I misconfigured?
my current pg conf:
shared_buffers=60000
wal_buffers=8
sort_mem=512
vacuum_mem=8192
OS conf:
shmmax=535404544
shmmin=1
shmmni=192
shmseg=256
shmall=130714
shm_use_phys=1
OS: FreeBSD-4.6.2
DB: Postgresql-7.2.1
Thanks.
Jie Liang