From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
---|---|
To: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
Cc: | Carlo Stonebanks <stonec(dot)register(at)sympatico(dot)ca>, pgsql-performance(at)postgresql(dot)org, Devrim GUNDUZ <devrim(at)commandprompt(dot)com> |
Subject: | Re: New server to improve performance on our large and busy DB - advice? |
Date: | 2010-01-21 16:44:40 |
Message-ID: | 20100121164440.GC3423@alvh.no-ip.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Scott Marlowe escribió:
> On Thu, Jan 21, 2010 at 8:51 AM, Alvaro Herrera
> <alvherre(at)commandprompt(dot)com> wrote:
> > Scott Marlowe escribió:
> >> On Thu, Jan 14, 2010 at 12:17 PM, Carlo Stonebanks
> >> <stonec(dot)register(at)sympatico(dot)ca> wrote:
> >
> >> > 4) Is this the right PG version for our needs?
> >>
> >> 8.3 is very stable. Update to the latest. 8.4 seems good, but I've
> >> had, and still am having, problems with it crashing in production.
> >> Not often, maybe once every couple of months, but just enough that I'm
> >> not ready to try and use it there yet. And I can't force the same
> >> failure in testing, at least not yet.
> >
> > uh. Is there a report of the crash somewhere with details, say stack
> > traces and such?
>
> No, the only server that does this is in production as our stats db
> and when it happens it usually gets restarted immediately. It does
> this about once every two months. Do the PGDG releases have debugging
> symbols and what not? I'll see about having a stack trace ready to
> run for the next time it does this.
You mean the RPMs? Yes, I think Devrim publishes debuginfo packages
which you need to install separately.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2010-01-21 16:49:55 | Re: New server to improve performance on our large and busy DB - advice? |
Previous Message | Scott Marlowe | 2010-01-21 16:41:19 | Re: New server to improve performance on our large and busy DB - advice? |