| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | John Summerfield <summer(at)os2(dot)ami(dot)com(dot)au> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: Excess disk usage |
| Date: | 2001-09-03 22:09:50 |
| Message-ID: | 6784.999554990@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
John Summerfield <summer(at)os2(dot)ami(dot)com(dot)au> writes:
> I attempted to load data amounting to 21 mbytes into a table which has
> a unique key both otherwise doesn't have indexes.
> The WALs consumed 2.9 Gigabytes of disk (and doubtless would have taken
> more if there was more to be had).
That seems like a large growth factor. What is the exact schema
declaration of the table, and how are you measuring the "21 mbytes"?
The immediate problem should be fixed if you update to 7.1.3, but
I'm curious about the 100:1 WAL-size-to-data-size ratio that you're
reporting.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-09-03 22:55:55 | Re: Odp: PD: triggered data change violation on relation "tbl_b" |
| Previous Message | Tom Lane | 2001-09-03 19:35:11 | Re: Re: low performance |