Re: asynchronous commit
От | Andreas Kretschmer |
---|---|
Тема | Re: asynchronous commit |
Дата | |
Msg-id | 20150120172135.GB16478@tux обсуждение исходный текст |
Ответ на | Re: asynchronous commit (Robert DiFalco <robert.difalco@gmail.com>) |
Список | pgsql-general |
Robert DiFalco <robert.difalco@gmail.com> wrote: > Andreas, I think UNLOGGED would be something different but I'm not totally > clear. However, it seems to me that an unlogged table would simply disappear > (be truncated) after a server crash. That means instead of maybe loosing a > record or two that I could loose a ton or records. But maybe my understanding > is off. That's correct. Maybe you can solve the performance issue with unlogged tables, but yes, you have to save the records into a regular table. Maybe via Cron or so. (rough, with move as (delete from unlogged returning *) insert into regular_table select * from move, or something similar.) Sorry for the delay. Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvalds) "If I was god, I would recompile penguin with --enable-fly." (unknown) Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
В списке pgsql-general по дате отправления: