Re: [PERFORM] Getting even more insert performance (250m+rows/day)

[Daniel J. Luke]

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 should

give 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 beefier

hardware, of course. :-)

Thanks!

--
Daniel J. Luke
+========================================================+
| *---------------- [EMAIL PROTECTED] ----------------* |
| *-------------- http://www.geeklair.net -------------* |
+========================================================+
|   Opinions expressed are mine and do not necessarily   |
|          reflect the opinions of my employer.          |
+========================================================+

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).

PGP.sig
Description: This is a digitally signed message part