Tatsuo, would you please comment on this patch? ---------------------------------------------------------------------------
ITAGAKI Takahiro wrote: > 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, skipping... ] > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings -- Bruce Momjian <[EMAIL PROTECTED]> http://momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
