| From: | "Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Huge number of disk writes after migration to 8.1 |
| Date: | 2006-01-16 22:09:18 |
| Message-ID: | dqh5fv$2v2e$1@news.hub.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-general |
"Marcin" <migor(at)op(dot)pl> wrote
>
> I suffer from huge increase in number of disk writes after migration
> from 8.0.3 to 8.1.2. The average number of sectors written increased 10
> times and transfer stays at 20MB of writes per second during work hours
> (with 20% cpu time wasted in iowait). The number of queries lasting more
> than 300ms increased thrice.
>
AFAICS the difference maybe related to this between 8.0 and 8.1 is the
introduction of autovacuum. But seems you didn't turn it on. Do you observed
only writes increased or both read/write? If the latter, that might be an
unoptimized query plan invloves seqscan ... Can you find out what's the
writes on?
Regards,
Qingqing
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Roberto | 2006-01-16 23:55:12 | BUG #2175: 22021: invalid byte sequence for encoding \"UNICODE\": |
| Previous Message | Marcin | 2006-01-16 18:09:09 | Huge number of disk writes after migration to 8.1 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim C. Nasby | 2006-01-16 22:27:29 | Re: Unable to connect to a dabase |
| Previous Message | Zlatko Matić | 2006-01-16 21:50:20 | linking temporary tables from MS Access? |