Re: WAL file location - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: WAL file location
Date
Msg-id Pine.LNX.4.44.0207310001350.6899-100000@localhost.localdomain
Whole thread Raw
In response to Re: WAL file location  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: WAL file location
List pgsql-hackers
Bruce Momjian writes:

> Thomas, are you going to extend this to locations for any table/index?
> Seems whatever we do for WAL should fix in that scheme.

The trick is that it might not.  For relations you simply need a system
table mapping location names to file system locations, and you can add and
remove those mappings at will.  Moving an object between locations can be
accomplished by locking the object down, moving the files, updating the
system catalogs, and unlocking.

But the location of the WAL logs, and the commit logs, if anyone is
thinking in that direction, needs to be known to initdb.  And if you want
to move them later you'd need to halt the entire system or implement some
smarts for transition.  So I'm not sure if these things fit under one
umbrella.  It would probably be nice if they did.

-- 
Peter Eisentraut   peter_e@gmx.net



pgsql-hackers by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: Re: Open 7.3 items
Next
From: Andrew Sullivan
Date:
Subject: Re: Trim the Fat (Was: Re: Open 7.3 items )