Re: Truncation of UNLOGGED tables upon restart.
От | Ravi Krishna |
---|---|
Тема | Re: Truncation of UNLOGGED tables upon restart. |
Дата | |
Msg-id | 1177060548.6477958.1541107219801@mail.yahoo.com обсуждение исходный текст |
Ответ на | Re: Truncation of UNLOGGED tables upon restart. ("David G. Johnston" <david.g.johnston@gmail.com>) |
Ответы |
Re: Truncation of UNLOGGED tables upon restart.
|
Список | pgsql-general |
> There is no such thing as a "read only" table in PostgreSQL. All tables are read/write no matter that frequency of eitherevent. There is nothing > inherently special about "no writes for 4 days" and "no writes for 10 seconds" that wouldallow for a distinction to be made. There could be write > in progress on the table just as it crashes Friday. I am aware that unlogged tables have no entries in WAL, but I assumed (incorrectly) that PG will at least keep track whetherany writes was done on a table since last checkpoint, and if none, it will find no reason to truncate it. The use case I was thinking about is that if we have to load a large set of data every weekend and use it for reporting untilnext weekend, why not create those tables as unlogged.
В списке pgsql-general по дате отправления: