| From: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | "Peter Childs" <peterachilds(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: 8.3b1 in production? |
| Date: | 2007-10-25 15:31:05 |
| Message-ID: | dcc563d10710250831ue4d776dn761e077a03df2348@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 10/25/07, Peter Childs <peterachilds(at)gmail(dot)com> wrote:
> I was wondering why my PITR base back up was taking 2 hours on my 8.3 test
> database where as it takes 50 minutes on 8.1 and the database files are
> meant to be smaller on a freshly installed 8.3 server rather than a 8.1.1
> server that aint been rebuilt since 8.1.1 was newly out.
> I was planning to upgrade to 8.3 once its out...
>
> Down time for upgrades is somwhat lacking in a 24x7 business.
>
> Oh my 8.1 server has been up for well over a year with out being down at
> all. the database for longer which really show how good postgres really is
> 377 days uptime on computer and I think that was to move a plug.
You should really look at scheduling the 5 minute window up update
your 8.1 install. 8.1.1 is quite old and has a few known data eating
bugs, if I remember correctly. Updating to 8.1.10 should only take
literally about 1 or 2 minutes.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2007-10-25 15:32:25 | Re: select count() out of memory |
| Previous Message | Scott Marlowe | 2007-10-25 15:27:36 | Re: select count() out of memory |