Try wrapping all your inserts in a transaction:
pg_query('BEGIN');
// your inserts
pg_query('COMMIT');
That way you won't have to sync each of those inserts to disk, should
provide a huge speedup. Of course this means your 10,000 inserts will be
all or nothing, but it seems like in this case tha
Thank you everybody for the detailed answers, the help is well appreciated.
A couple of follow-up questions:
- Is the supercap + flash memory considered superior to the BBU in practice?
Is that type of system well tested?
- Is the linux support of the LSI and Adaptec cards comparable?
-Dan
On W
I'm setting up a dedicated linux postgres box with 2x300GB 15k SAS drive in
a RAID 1, though if future load dictates we would like to be able to upgrade
to RAID 10. The hosting provider offers the following options for a RAID
controller (all are the same price):
ADAPTEC 3405 RAID Controller
ADA
