| From: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
|---|---|
| To: | Oliver Kohll <oliver(dot)lists(at)gtwm(dot)co(dot)uk> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Unlogged table restart |
| Date: | 2011-09-12 22:07:01 |
| Message-ID: | CAHyXU0wU3xTGoYk3X4hpEj+uSyd1k05d0r+0Cte4yYqb_X0OXg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, Sep 12, 2011 at 3:56 PM, Oliver Kohll <oliver(dot)lists(at)gtwm(dot)co(dot)uk> wrote:
> Hi, great to see unlogged tables. There was discussion in the lists a while ago about various options for what would happen on server restart. I understand after a crash they'll be truncated but what about after a clean restart? Are they guaranteed to retain all committed data? If so I'll definitely use them for frequently written logs, if not I may still do so but will need some extra backup steps.
Per the documentation they are only cleared following an unclean
shutdown...(http://www.postgresql.org/docs/9.1/static/sql-createtable.html)
merlin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dylan Adams | 2011-09-12 22:27:41 | Re: Index Corruption |
| Previous Message | Oliver Kohll | 2011-09-12 20:56:44 | Unlogged table restart |