Re: Slow PITR restore - Mailing list pgsql-general

From Jeff Trout
Subject Re: Slow PITR restore
Date
Msg-id 368FED09-A777-45AF-A92C-25A171DB6ACF@torgo.978.org
Whole thread Raw
In response to Re: Slow PITR restore  (Gregory Stark <stark@enterprisedb.com>)
Responses Re: Slow PITR restore  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-general
On Dec 12, 2007, at 1:02 PM, Gregory Stark wrote:
>
> I'm not sure what you guys' expectations are, but if you're
> restoring 5
> minutes worth of database traffic in 8 seconds I wouldn't be
> complaining.
>
> Depending on your transaction mix and what percentage of it is read-
> only
> select queries you might reasonably expect the restore to take as
> long as it
> took to generate them...
>

in this case it was 24hrs of data - about 1500 wal segments.  During
this time the machine was nearly complete idle and there wasn't very
much IO going on (few megs/sec).

I'll have to artifically build up some db traffic on an 8.3 instance
to see if the patch Tom mentioned helps.


--
Jeff Trout <jeff@jefftrout.com>
http://www.dellsmartexitin.com/
http://www.stuarthamm.net/




pgsql-general by date:

Previous
From: Samantha Atkins
Date:
Subject: Re: what is the date format in binary query results
Next
From: TJ O'Donnell
Date:
Subject: Re: Function to convert from TEXT to BYTEA?