Streaming replication and temp table operations
От | Joel Stevenson |
---|---|
Тема | Streaming replication and temp table operations |
Дата | |
Msg-id | 8B5BB148-9652-4AD3-BB59-EF9426665364@bepress.com обсуждение исходный текст |
Ответы |
Re: Streaming replication and temp table operations
Re: Streaming replication and temp table operations |
Список | pgsql-general |
Hi all, Does anyone know if temp tables and the operations on them (like inserting or copying to) are replicated from master to standbyservers via the new PG WAL shipping replication? Given that temp tables are only accessible per-session it wouldseem unnecessary but if the shipping is happening at the WAL log level is that sort of thing considered? Specifically I've got a table that I want to get some representative statistics and explain plans on prior to making it liveon a production environment and so I was considering creating a temp table to populate with a sizable chunk of representativetest data on the master database installation. The Streaming Replication docs ( 25.2.5 ) state: "If you use streaming replication without file-based continuous archiving, you have to set wal_keep_segments in the masterto a value high enough to ensure that old WAL segments are not recycled too early, while the standby might still needthem to catch up. If the standby falls behind too much, it needs to be reinitialized from a new base backup. If you setup a WAL archive that's accessible from the standby, wal_keep_segments is not required as the standby can always use thearchive to catch up." Which, in the streaming replication w/o file-based continuous archiving scenario, seems like I'd want to be absolutely certainthat this setting was big enough to handle whatever data was being imported into the temp table via a COPY...FROMeven if the actual table wasn't being replicated. Does anyone know if this is a valid concern and whether or not the temp table will be replicated (regardless of the use offile-based continuous archiving)? Thanks in advance, Joel
В списке pgsql-general по дате отправления: