Re: MultiXacts & WAL - Mailing list pgsql-hackers

From Tom Lane
Subject Re: MultiXacts & WAL
Date
Msg-id 23001.1150576665@sss.pgh.pa.us
Whole thread Raw
In response to Re: MultiXacts & WAL  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
Josh Berkus <josh@agliodbs.com> writes:
>> Please dump some of the WAL segments with xlogdump so we can get a
>> feeling for what's in there.

> OK, will do on Monday's test run.   Is it possible for me to run this at the 
> end of the test run, or do I need to freeze it in the middle to get useful 
> data?

I'd just copy off a random sample of WAL segment files while the run is
proceeding.  You don't need very many, half a dozen at most.

> Also, we're toying with the idea of testing full_page_writes=off for Solaris.
> The Solaris engineers claim that it should be safe on Sol10 + Sun hardware.  
> I'm not entirely sure that's true; is there a destruction test of the bug 
> that caused us to remove that option?

The bug that made us turn it off in the 8.1 branch had nothing to do
with hardware reliability or the lack thereof.  As for testing, will
they let you yank the power cord?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: MultiXacts & WAL
Next
From: Tom Lane
Date:
Subject: Rethinking stats communication mechanisms