Re: [HACKERS] lazy vxid locks, v2

2011-07-17 Thread Robert Haas
On Fri, Jul 15, 2011 at 4:41 PM, Josh Berkus j...@agliodbs.com wrote: (1) can you re-link me to the pgbench and sysbench setup you used to test this originally?  I'd like to implement those. I didn't use sysbench. The pgbench command I used was something like: pgbench -n -S -T $TIME -c

Re: [HACKERS] lazy vxid locks, v2

2011-07-15 Thread Josh Berkus
Robert, I should be able to do some performance testing on this, but not today. Questions: (1) can you re-link me to the pgbench and sysbench setup you used to test this originally? I'd like to implement those. (2) the max machine I can test these on is 16 cores. Is that adequate, or do we

Re: [HACKERS] lazy vxid locks, v2

2011-07-14 Thread Jeff Davis
On Tue, 2011-07-05 at 13:15 -0400, Robert Haas wrote: On Tue, Jul 5, 2011 at 1:13 PM, Robert Haas robertmh...@gmail.com wrote: Here is an updated version of the lazy vxid locks patch [1], which applies over the latest reduce the overhead of frequent table locks[2] patch. [1]

[HACKERS] lazy vxid locks, v2

2011-07-05 Thread Robert Haas
Here is an updated version of the lazy vxid locks patch [1], which applies over the latest reduce the overhead of frequent table locks[2] patch. [1] https://commitfest.postgresql.org/action/patch_view?id=585 [2] https://commitfest.postgresql.org/action/patch_view?id=572 -- Robert Haas

Re: [HACKERS] lazy vxid locks, v2

2011-07-05 Thread Robert Haas
On Tue, Jul 5, 2011 at 1:13 PM, Robert Haas robertmh...@gmail.com wrote: Here is an updated version of the lazy vxid locks patch [1], which applies over the latest reduce the overhead of frequent table locks[2] patch. [1] https://commitfest.postgresql.org/action/patch_view?id=585 [2]