| From: | Jeff Trout <threshar(at)torgo(dot)978(dot)org> |
|---|---|
| To: | Gregory Stark <stark(at)enterprisedb(dot)com> |
| Cc: | "Jeff Trout" <threshar(at)real(dot)jefftrout(dot)com>, "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Slow PITR restore |
| Date: | 2007-12-12 18:13:35 |
| Message-ID: | 368FED09-A777-45AF-A92C-25A171DB6ACF@torgo.978.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
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(at)jefftrout(dot)com>
http://www.dellsmartexitin.com/
http://www.stuarthamm.net/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | TJ O'Donnell | 2007-12-12 18:14:10 | Re: Function to convert from TEXT to BYTEA? |
| Previous Message | Samantha Atkins | 2007-12-12 18:12:37 | Re: what is the date format in binary query results |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2007-12-12 18:19:40 | Re: Slow PITR restore |
| Previous Message | Joshua D. Drake | 2007-12-12 18:08:08 | Re: Slow PITR restore |