| From: | Jie Liang <jie(at)stbernard(dot)com> |
|---|---|
| To: | 'Tom Lane' <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | 3 million record updates |
| Date: | 2002-10-05 00:05:46 |
| Message-ID: | 7C760DAA511DC74B99E7D22189F786F101BF2207@mail01.stbernard.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hubert depesz Lubaczewski | 2002-10-05 08:21:36 | Re: Fast Deletion For Large Tables |
| Previous Message | Chris Miles | 2002-10-04 21:13:02 | Re: PostgreSQL and 2-node failover cluster solutions |