Robert Haas robertmh...@gmail.com writes:
Basically, for every unlogged table, you get an empty _init fork, and
for every index of an unlogged table, you get an _init fork
initialized to an empty index. The _init forks are copied over the
main forks by the startup process before entering
[ moving to -hacker s]
On Thu, Sep 22, 2011 at 9:26 PM, Thom Brown t...@linux.com wrote:
On 22 September 2011 17:38, Josh Berkus j...@agliodbs.com wrote:
So are there any plans to allow swappable drive/volatile storage
unlogged tables?
Be our guest. ;-)
Oh it can't be that difficult. On
On 23 September 2011 15:12, Robert Haas robertmh...@gmail.com wrote:
[ moving to -hacker s]
On Thu, Sep 22, 2011 at 9:26 PM, Thom Brown t...@linux.com wrote:
On 22 September 2011 17:38, Josh Berkus j...@agliodbs.com wrote:
So are there any plans to allow swappable drive/volatile storage
On Fri, Sep 23, 2011 at 10:37 AM, Thom Brown t...@linux.com wrote:
Couldn't this come under tablespace changes then? After all the
use-case stated would require a separate tablespace, and you could do
something like:
CREATE VOLATILE TABLESPACE drive_made_of_wax_left_in_the_sun LOCATION
On Fri, Sep 23, 2011 at 10:54 AM, Robert Haas robertmh...@gmail.com wrote:
CREATE TABLESPACE now_you_see_me_now_you_dont LOCATION
'/mnt/highly_reliable_san' VOLATILE LOCATION '/mnt/ramdisk';
All forks of temporary relations, and all non-_init forks of
non-temporary relations, could be stored
On 23 September 2011 15:56, Robert Haas robertmh...@gmail.com wrote:
On Fri, Sep 23, 2011 at 10:54 AM, Robert Haas robertmh...@gmail.com wrote:
CREATE TABLESPACE now_you_see_me_now_you_dont LOCATION
'/mnt/highly_reliable_san' VOLATILE LOCATION '/mnt/ramdisk';
All forks of temporary relations,
On Fri, Sep 23, 2011 at 11:36 AM, Thom Brown t...@linux.com wrote:
On 23 September 2011 15:56, Robert Haas robertmh...@gmail.com wrote:
On Fri, Sep 23, 2011 at 10:54 AM, Robert Haas robertmh...@gmail.com wrote:
CREATE TABLESPACE now_you_see_me_now_you_dont LOCATION
'/mnt/highly_reliable_san'