| From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | Joel Stevenson <jstevenson(at)bepress(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Streaming replication and temp table operations |
| Date: | 2011-06-21 20:47:00 |
| Message-ID: | BANLkTik9TY_XT=+jcsrXuD_fGZ7gi+nRCw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Jun 21, 2011 at 2:15 PM, Joel Stevenson <jstevenson(at)bepress(dot)com> wrote:
> Hi all,
>
> Does anyone know if temp tables and the operations on them (like inserting or copying to) are replicated from master to standby servers via the new PG WAL shipping replication? Given that temp tables are only accessible per-session it would seem unnecessary but if the shipping is happening at the WAL log level is that sort of thing considered?
Pretty sure that with 9.0's streaming replication, the no WAL of temp
tables gets turned off. I've certainly seen references to such float
by. But I'd check the docs to be sure.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Grittner | 2011-06-21 21:40:35 | abusing session_replication_mode |
| Previous Message | Greg Smith | 2011-06-21 20:37:57 | Re: Tuning for a tiny database |