Re: [PERFORM] Hardware suggestions for maximum read performance

2013-05-05 Thread Yuri Levinsky
Mike, According to your budget the following or similar might be useful for you: HP 365GB Multi Level Cell G2 PCIe ioDrive2 for ProLiant Servers This PCIe card-based direct-attach solid state storage technology solutions for application performance enhancement. I believe you can find cheaper

Re: [PERFORM] In progress INSERT wrecks plans on table

2013-05-05 Thread Mark Kirkwood
On 05/05/13 00:49, Simon Riggs wrote: On 3 May 2013 13:41, Simon Riggs wrote: (3) to make the check on TransactionIdIsInProgress() into a heuristic, since we don't *need* to check that, so if we keep checking the same xid repeatedly we can reduce the number of checks or avoid xids that seem to