Re: Tablespaces on tertiary media
От | Gregory Stark |
---|---|
Тема | Re: Tablespaces on tertiary media |
Дата | |
Msg-id | 87bqc5o95y.fsf@oxford.xeocode.com обсуждение исходный текст |
Ответ на | Tablespaces on tertiary media (Mark Morgan Lloyd <markMLl.pgsql-general@telemetry.co.uk>) |
Ответы |
Re: Tablespaces on tertiary media
|
Список | pgsql-general |
"Mark Morgan Lloyd" <markMLl.pgsql-general@telemetry.co.uk> writes: > Where does PostgreSQL stand with storing /really/ large amounts of data > offline? Specifically, if a FUSE is used to move a tablespace to something like > a tape archiver can the planner be warned that access might take an extended > period? No, Postgres can't deal with this. You'll have to dump the tables with pg_dump or COPY or something like that and then drop them from the database. If you need them again you have to load them again. Actually if the tables are missing but nobody tries to access them (including autovacuum) then nothing will notice they're missing. But if you do try to access them you'll get an error. And if you leave it in this situation too long your database will shut down from getting too close to transaction wraparound. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com
В списке pgsql-general по дате отправления: