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

2013-07-13 Thread Jeff Janes
On Sunday, June 16, 2013, Heikki Linnakangas wrote: > On 06.05.2013 04:51, Mark Kirkwood wrote: > >> 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 c

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

2013-07-13 Thread Ants Aasma
On Sat, Jul 13, 2013 at 1:47 AM, Jeff Janes wrote: > But I also tried it with 4 pgbench clients, and ran into a collapse of > the performance, TPS dropping down to ~8 TPS. It is too variable to > figure out how reliable the speed-up with this patch is, so far. > Apparently they are all fighting