On May 24, 2006, at 4:03 PM, Steinar H. Gunderson wrote:
Have you tried fiddling with the checkpointing settings? Check your logs -- if you get a warning about checkpoints being too close together, that shouldgive you quite some boost.
no warnings in the log (I did change the checkpoint settings when I set up the database, but didn't notice an appreciable difference in insert performance).
Apart from that, you should have quite a bit to go on -- somebody on this list reported 2 billion rows/day earlier, but it might have been on beefierhardware, of course. :-)
Probably :) I'll keep searching the list archives and see if I find anything else (I did some searching and didn't find anything that I hadn't already tried).
Thanks! -- Daniel J. Luke +========================================================+ | *---------------- dluke@xxxxxxxxxxxx ----------------* | | *-------------- http://www.geeklair.net -------------* | +========================================================+ | Opinions expressed are mine and do not necessarily | | reflect the opinions of my employer. | +========================================================+
Attachment:
PGP.sig
Description: This is a digitally signed message part
