Re: Index build temp files
Stephen Frost <sfrost@snowman.net>
From: Stephen Frost <sfrost@snowman.net>
To: Simon Riggs <simon@2ndQuadrant.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Bruce Momjian <bruce@momjian.us>, pgsql-hackers@postgresql.org
Date: 2013-01-09T20:53:05Z
Lists: pgsql-hackers
* Simon Riggs (simon@2ndQuadrant.com) wrote: > I think we need to allow a TEMP permission on tablespaces, so that you > aren't allowed to create normal objects but you can create TEMP > objects and sort files there. I agree that this would be valuable. Would we end up needing to burn another bit off the aclmask though? That's certainly been a concern in the past and I don't recall that we ever improved that situation. > I think SHOW temp_tablespaces should only show the valid tablespaces, > not all of the ones actually listed in the parameter, otherwise you > have no clue that the parameter setting is ineffectual for you. I like this as well. Thanks, Stephen