Mark Kirkwood wrote: > Its worth checking - isn't it ? > > I appeciate that you may have performed such tests previously - but as > hardware and software evolve its often worth repeating such tests (goes > away to do the suggested one tonight). > > Note that I am not trying to argue away the issue about write caching - > it *has* to increase the risk of database corruption following a power > failure, however if your backups are regular and reliable this may be a > risk worth taking to achieve acceptable performance at a low price.
Sure, but how many people are taking that risk and not knowing it! -- 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
