Re: [PERFORM] Optimizing for writes. Data integrity not critical

2005-05-21 Thread Alex Stapleton
I am interested in optimising write performance as well, the machine I am testing on is maxing out around 450 UPDATEs a second which is quite quick I suppose. I haven't tried turning fsync off yet. The table has...a lot of indices as well. They are mostly pretty simple partial indexes thoug

Re: [PERFORM] Optimizing for writes. Data integrity not critical

2005-05-21 Thread Alex Stapleton
Is using a ramdisk in situations like this entirely ill-advised then? When data integrity isn't a huge issue and you really need good write performance it seems like it wouldn't hurt too much. Unless I am missing something? On 20 May 2005, at 02:45, Christopher Kings-Lynne wrote: I'm doing