| From: | Alban Hertroys <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl> |
|---|---|
| To: | Jayadevan M <Jayadevan(dot)Maymala(at)ibsplc(dot)com> |
| Cc: | Andy Colson <andy(at)squeakycode(dot)net>, PostgreSQL general <pgsql-general(at)postgresql(dot)org>, pgsql-general-owner(at)postgresql(dot)org |
| Subject: | Re: Survey on backing up unlogged tables: help us with PostgreSQL development! |
| Date: | 2010-11-19 07:16:38 |
| Message-ID: | 9CBFDA16-3F11-4FCC-A5BA-0A256A5D45E4@solfertje.student.utwente.nl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 19 Nov 2010, at 4:23, Jayadevan M wrote:
> Hi,
>
>>> One doubt - if the tables are 'unlogged' , will the DMLs against these
>>> still be replicated to a slave?
>>>
>>
>> Yes, because the system tables, which store the layout of all tables, is
>
>> written to WAL.
> Thank you for the reply. But my doubt was not about layout, rather the
> DMLs. If I do an insert into an 'unlogged' table, what happens to that?
> Will that be replicated in the slave (using PostgreSQL's inbuilt
> replication)?
What are the use-cases for replicating unlogged tables?
Alban Hertroys
--
If you can't see the forest for the trees,
cut the trees and you'll see there is no forest.
!DSPAM:737,4ce6246e10421025920086!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marc Mamin | 2010-11-19 07:41:00 | Re: Survey on backing up unlogged tables: help us with PostgreSQL development! |
| Previous Message | Tom Lane | 2010-11-19 04:56:32 | Re: How to identify whether the stats were reset? |