I'm now writing v3 patch of PITR improvement, to work with sync.rep
and Hot Standby.Would like to change the thread.
2008/12/12 Pavan Deolasee :
> On Fri, Dec 12, 2008 at 9:08 AM, Koichi Suzuki wrote:
>> Hmmm, it's really like pg_readahead needs to be included in the core.
>> I don't think
On Fri, Dec 12, 2008 at 9:08 AM, Koichi Suzuki wrote:
> Hmmm, it's really like pg_readahead needs to be included in the core.
> I don't think it's a big work and will try to do this.
>
Yes, I think it's best to have it in core. I would actually combine it
with the other idea of reading xlog fi
Hmmm, it's really like pg_readahead needs to be included in the core.
I don't think it's a big work and will try to do this.
2008/12/9 Fujii Masao :
> Hi,
>
> On Mon, Dec 8, 2008 at 2:54 PM, Koichi Suzuki wrote:
>> I understood your point. In the case of synchronous replication,
>> because s
Hi,
On Mon, Dec 8, 2008 at 2:54 PM, Koichi Suzuki <[EMAIL PROTECTED]> wrote:
> I understood your point. In the case of synchronous replication,
> because slave fails over when master crashes, there're no need to
> leave FPW from the beginning.
>
> In this case, only prefetch will work. Fujii's
I understood your point. In the case of synchronous replication,
because slave fails over when master crashes, there're no need to
leave FPW from the beginning.
In this case, only prefetch will work. Fujii's code at the slave
looks very similar to pg_standby and pg_readahead will help in this
Hi,
On Thu, Dec 4, 2008 at 6:11 PM, Simon Riggs <[EMAIL PROTECTED]> wrote:
>
> On Wed, 2008-12-03 at 14:22 +0900, Koichi Suzuki wrote:
>
>> > There's clearly a huge gain using prefetch, when we have
>> > full_page_writes = off. But that does make me think: Why do we need
>> > prefetch at all if we
On Wed, 2008-12-03 at 14:22 +0900, Koichi Suzuki wrote:
> > There's clearly a huge gain using prefetch, when we have
> > full_page_writes = off. But that does make me think: Why do we need
> > prefetch at all if we use full page writes? There's nothing to prefetch
> > if we can keep it in cache.
Agreed.
I borrowed WAL parsing code from XLogdump and I think WAL parsing
should be another candidate.
2008/12/3 Fujii Masao <[EMAIL PROTECTED]>:
> Hi,
>
> On Thu, Nov 27, 2008 at 9:04 PM, Koichi Suzuki <[EMAIL PROTECTED]> wrote:
>> Please find enclosed a revised version of pg_readahead and a pat
Hi,
On Thu, Nov 27, 2008 at 9:04 PM, Koichi Suzuki <[EMAIL PROTECTED]> wrote:
> Please find enclosed a revised version of pg_readahead and a patch to
> invoke pg_readahead.
Some similar functions are in xlog.c and pg_readahead.c (for example,
RecordIsValid). I think that we should unify them as a
Hi,
As to checkpoint timeout, yes, this measurement is hard for FPW=on
case. I'll do the similar measurement for checkpoint timeout = 5min
and post the result. I expect that the recoevry time will be almost
the same in the case FPW=on, lesslog=yes and prefetpch = yes.
2008/12/2 Simon Riggs <[E
On Thu, 2008-11-27 at 21:04 +0900, Koichi Suzuki wrote:
> We ran the
> benchmark for on hour with chekpoint timeout 30min and completion_target 0.5.
> Then, collected all the archive log and run PITR.
> --+++---
> WAL conditions
11 matches
Mail list logo
