I'm trying to increase the speed of inserts in a database that is on a not super fast storage system. I have installed a pair of SSDs and placed pg_xlog on them but am still getting inserts that take up to a second to complete, with .3 seconds being about average. Iostat doesn't show the SSDs stressed at all, and changing synchronous_commit doesn't seem to affect it one way or the other. Where would I look next for what could be causing the delay?
- [PERFORM] WAL + SSD = slow inserts? Skarsol
- Re: [PERFORM] WAL + SSD = slow inserts? desmodemone
- Re: [PERFORM] WAL + SSD = slow inserts? Skarsol
- Re: [PERFORM] WAL + SSD = slow inserts? Scott Marlowe
- Re: [PERFORM] WAL + SSD = slow inserts? Skarsol
- Re: [PERFORM] WAL + SSD = slow insert... Scott Marlowe
- Re: [PERFORM] WAL + SSD = slow in... bricklen
- Re: [PERFORM] WAL + SSD = slo... Skarsol
- Re: [PERFORM] WAL + SSD = slo... Rosser Schwarz
- Re: [PERFORM] WAL + SSD = slow insert... Mark Kirkwood
- Re: [PERFORM] WAL + SSD = slow insert... Tomas Vondra