Re: Inserts optimization?

Tom Lane writes:

> Or at least try to do multiple inserts per transaction.

Will see if the program has an option like that.


> Also, increasing checkpoint_segments and possibly wal_buffers helps a

Will try those.

>Try to get the WAL onto a separate disk
>spindle if you can.  (These things don't matter for SELECTs, but they
>do matter for writes.)

This particular server is pretty much what I inherited for now for this
project.and its Raid 5. There is a new server I am setting up
soon... 8 disks which we are planning to setup
6 disks in RAID 10
2 Hot spares

In RAID 10 would it matter that WALL is in the same RAID set?
Would it be better:
4 disks in RAID10 Data
2 disks RAID 1 WALL
2 hot spares

All in the same RAID controller