Decibel! wrote: -- Start of PGP signed section. > On Thu, Aug 09, 2007 at 09:57:48AM +0900, ITAGAKI Takahiro wrote: > > > If HOT gets into 8.3, we might need a GUC to set database wide heap > > > fillfactor to an appropriate value. > > > > I have no objection to do that, but we will need other default values soon, > > something like default_[heap|btree|hash|gist|gin]_fillfactor. Some of us > > might feel it is mess to add random guc variables. > > I think we'd want to handle indexes with a different mechanism, probably > one that makes changes to pg_am. > > In any case, how important is it to do this before 8.3? We were supposed > to release this month, after all.
Agreed. This seems like 8.4 material once we have HOT usage in the field. -- 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
