| From: | ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp> |
|---|---|
| To: | pgsql-patches(at)postgresql(dot)org |
| Subject: | Optimized pgbench for 8.3 |
| Date: | 2007-03-05 07:11:12 |
| Message-ID: | 20070305154413.C4B1.ITAGAKI.TAKAHIRO@oss.ntt.co.jp |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
The attached is a patch to optimize contrib/pgbench using new 8.3 features.
- Use DROP IF EXISTS to suppress errors for initial loadings.
- Use a combination of TRUNCATE and COPY to reduce WAL on creating
the accounts table.
Also, there are some cosmetic changes.
- Change the output of -v option from "starting full vacuum..."
to "starting vacuum accounts..." in reflection of the fact.
- Shape duplicated error checks into executeStatement().
There is a big performance win in "COPY with no WAL" feature.
Thanks for the efforts!
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
| Attachment | Content-Type | Size |
|---|---|---|
| pgbench-8.3.patch | application/octet-stream | 10.6 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Grzegorz Jaskiewicz | 2007-03-05 08:17:06 | Re: Bug: Buffer cache is not scan resistant |
| Previous Message | Tom Lane | 2007-03-05 06:25:42 | Re: Bug: Buffer cache is not scan resistant |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | ITAGAKI Takahiro | 2007-03-05 08:22:16 | Re: Automatic adjustment of bgwriter_lru_maxpages |
| Previous Message | ITAGAKI Takahiro | 2007-03-05 04:11:46 | Automatic adjustment of bgwriter_lru_maxpages (was: Dead Space Map version 2) |