Re: [HACKERS] Temp tables, pg_class_temp and AccessExclusiveLocks

2014-11-01 Thread Pavel Stehule
Hi good idea. Mix of these both strategies can be a base for global temp tables implementation. Pavel 2014-10-31 15:53 GMT+01:00 Simon Riggs : > While investigating how to reduce logging of AccessExclusiveLocks for > temp tables, I came up with the attached patch. > > My feeling was "that's an

Re: [HACKERS] Temp tables, pg_class_temp and AccessExclusiveLocks

2014-10-31 Thread Simon Riggs
On 31 October 2014 14:53, Simon Riggs wrote: > While investigating how to reduce logging of AccessExclusiveLocks for > temp tables, I came up with the attached patch. -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services temp_

[HACKERS] Temp tables, pg_class_temp and AccessExclusiveLocks

2014-10-31 Thread Simon Riggs
While investigating how to reduce logging of AccessExclusiveLocks for temp tables, I came up with the attached patch. My feeling was "that's an ugly patch", but it set me thinking that a more specialised code path around temp tables could be useful in other ways, and therefore worth pursuing furth