From:
Noah Misch <noah(at)leadboat(dot)com>
To:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc:
Stephen Frost <sfrost(at)snowman(dot)net>, Simon Riggs <simon(at)2ndQuadrant(dot)com>,Bruce Momjian <bruce(at)momjian(dot)us>, pgsql-hackers(at)postgresql(dot)org
Subject:
Re: Index build temp files
Date:
2013-01-10 02:36:55
Message-ID:
20130110023655.GB11600@tornado.leadboat.com (view raw or flat )
Thread:
2013-01-08 22:09:47 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-01-08 22:16:42 from Bruce Momjian <bruce(at)momjian(dot)us>
2013-01-08 22:21:54 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-01-09 00:04:32 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-01-09 00:16:24 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2013-01-09 00:23:18 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-01-09 02:25:48 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-01-09 02:42:59 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-01-09 04:38:17 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-01-09 04:49:49 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2013-01-09 04:55:08 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-01-09 05:05:38 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-01-09 19:56:08 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-01-09 20:00:19 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-01-09 20:20:33 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-01-09 20:49:47 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-01-09 21:03:44 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-01-09 21:21:18 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-01-10 02:36:55 from Noah Misch <noah(at)leadboat(dot)com>
2013-01-10 02:48:23 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2013-01-10 02:59:09 from Noah Misch <noah(at)leadboat(dot)com>
2013-01-10 04:02:58 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-01-10 09:48:23 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2013-01-10 13:59:14 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-01-09 20:15:46 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2013-01-09 20:53:05 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-01-09 21:08:55 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2013-01-09 21:21:03 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-01-09 21:27:38 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2013-01-09 21:42:06 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-01-09 21:52:31 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2013-01-09 22:09:54 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-01-09 22:47:15 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2013-01-09 23:12:48 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-01-09 23:40:28 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2013-01-09 23:09:59 from Stephen Frost <sfrost(at)snowman(dot)net>
Lists:
pgsql-hackers
On Wed, Jan 09, 2013 at 03:20:33PM -0500, Tom Lane wrote:
> What would people think of just eliminating the access-permissions
> checks involved in temp_tablespaces? It would likely be appropriate to
> change temp_tablespaces from USERSET to SUSET if we did so. So
> essentially the worldview would become that the DBA is responsible for
> the temp_tablespaces setting, not individual users.
Allowing that the new behavior could be clearer, that gain is too small to
justify the application compatibility hazard of making temp_tablespaces SUSET.
I don't see something we can do here that clearly improves things overall.
In response to
Responses
pgsql-hackers by date
Next :From: Simon RiggsDate: 2013-01-10 02:45:36Subject : Re: lazy_vacuum_heap()'s removal of HEAPTUPLE_DEAD tuplesPrevious :From : Bruce MomjianDate : 2013-01-10 02:22:48Subject : Lock levels for ALTER TABLE
