Re: Different transaction log for database/schema - Mailing list pgsql-general

From John R Pierce
Subject Re: Different transaction log for database/schema
Date
Msg-id 51ED7A8E.2000102@hogranch.com
Whole thread Raw
In response to Re: Different transaction log for database/schema  ("Ondrej Chaloupka" <chalda@seznam.cz>)
Responses Re: Different transaction log for database/schema
List pgsql-general
On 7/22/2013 9:33 AM, Ondrej Chaloupka wrote:
> thank you for the idea. I didn't know about the function.
> Just this probably won't work for my use case. I do not access to
> different databases in one transaction. I access different databases
> simultaneously each with it's own xa transaction. What I understand
> the switch_xlog servers for using new file for transaction log. What I
> would understand is supposed to be used e.g. for cleaning.

postgres servers don't really have a 'transaction log' in the same sense
as Oracle etc.   they have a 'write-ahead log' which works quite
differently.

in the context of postgres's WAL logs, your question doesn't make any
sense at all.



--
john r pierce                                      37N 122W
somewhere on the middle of the left coast



pgsql-general by date:

Previous
From: Jeff Janes
Date:
Subject: Re: odd locking behaviour
Next
From: Igor Neyman
Date:
Subject: Re: Different transaction log for database/schema