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

[Daniel J. Luke]

On May 24, 2006, at 4:02 PM, Dave Dutcher wrote:

If you can live with possible database corruption, you could try turning

Fsync off.  For example if you could just reinsert the data on the off

improvement.

chance a hardware failure corrupts the database, you might get a decent

I tried, but I didn't see much of an improvement (and it's not really acceptable for this application).

Also have you tried creating the index after you have inserted all your

data?  (Or maybe copy already disables the indexes while inserting?)

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

The data gets inserted in batches every 5 minutes and I potentially have people querying it constantly, so I can't remove and re-create the index.

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