Jan Wieck wrote: > On 8/7/2004 12:47 AM, Tom Lane wrote: > > > [EMAIL PROTECTED] (Jan Wieck) writes: > >> Vacuum delay activated by default. > > > > What? If there was consensus to do this, I missed it. If there was > > even any *discussion* of doing this, I missed it. > > > > regards, tom lane > > How many questions about vacuum still grabbing all available bandwidth, > vacuum slowing down the whole system, vacuum being all evil do you want > to answer for 8.0? Over and over again we are defending reasonable > default configuration values against gazillions of little switches, and > this is a reasonable default that will be a relief for large databases > and makes more or less no difference for small ones.
I haven't seen tons of complaints about vacuum myself. In addition it has already been pointed out that there is no one magic value that fixes it for everyone so some tuning is going to be needed anyway. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
