| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Koichi Suzuki <suzuki(dot)koichi(at)oss(dot)ntt(dot)co(dot)jp> |
| Cc: | Simon Riggs <simon(at)2ndquadrant(dot)com>, josh(at)agliodbs(dot)com, pgsql-hackers(at)postgresql(dot)org, pgsql-patches(at)postgresql(dot)org |
| Subject: | Re: [HACKERS] Full page writes improvement, code update |
| Date: | 2007-04-11 22:48:23 |
| Message-ID: | 6050.1176331703@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
Koichi Suzuki <suzuki(dot)koichi(at)oss(dot)ntt(dot)co(dot)jp> writes:
> For more information, when checkpoint interval is one hour, the amount
> of the archived log size was as follows:
> cp: 3.1GB
> gzip: 1.5GB
> pg_compresslog: 0.3GB
The notion that 90% of the WAL could be backup blocks even at very long
checkpoint intervals struck me as excessive, so I went looking for a
reason, and I may have found one. There has been a bug in CVS HEAD
since Feb 8 causing every btree page split record to include a backup
block whether needed or not. If these numbers were taken with recent
8.3 code, please retest with current HEAD.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Dunstan | 2007-04-11 22:52:47 | Re: Vista/IPv6 |
| Previous Message | Peter Eisentraut | 2007-04-11 22:24:58 | Re: Vista/IPv6 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-04-11 22:56:50 | Re: [PATCHES] Fix for large file support |
| Previous Message | Jason Lustig | 2007-04-11 22:02:48 | Slow Postgresql server |