Re: making an unlogged table logged
От | Josh Berkus |
---|---|
Тема | Re: making an unlogged table logged |
Дата | |
Msg-id | 4D24DB70.3040202@agliodbs.com обсуждение исходный текст |
Ответ на | Re: making an unlogged table logged ("A.M." <agentm@themactionfaction.com>) |
Ответы |
Re: making an unlogged table logged
Re: making an unlogged table logged |
Список | pgsql-hackers |
> Hm- if the unlogged tables are being used as HTTP transient state storage, it would be handy to have that (admittedly non-essential)data on the standby when it becomes master, even if there are no guarantees surrounding the data beyond "itlooked like this at some point". Since the tables are not writing WAL, would it be possible to allow for writing to unloggedtables on the standby to allow for out-of-band syncing? Otherwise, it seems the only alternative is to push changesto a separate database on the standby machine and then suck the data in when it becomes master. It would be useful (this would allow per-standby buffer tables, for that matter), but it would also be tremendously difficult. Seems worthy of a TODO, though. -- -- Josh Berkus PostgreSQL Experts Inc. http://www.pgexperts.com
В списке pgsql-hackers по дате отправления: