Re: New server to improve performance on our large and busy DB - advice?

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: New server to improve performance on our large and busy DB - advice?
Дата
Msg-id 20100121164440.GC3423@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: New server to improve performance on our large and busy DB - advice?  (Scott Marlowe <scott.marlowe@gmail.com>)
Ответы Re: New server to improve performance on our large and busy DB - advice?  (Scott Marlowe <scott.marlowe@gmail.com>)
Re: New server to improve performance on our large and busy DB - advice?  (Devrim GÜNDÜZ <devrim@gunduz.org>)
Список pgsql-performance
Scott Marlowe escribió:
> On Thu, Jan 21, 2010 at 8:51 AM, Alvaro Herrera
> <alvherre@commandprompt.com> wrote:
> > Scott Marlowe escribió:
> >> On Thu, Jan 14, 2010 at 12:17 PM, Carlo Stonebanks
> >> <stonec.register@sympatico.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.

В списке pgsql-performance по дате отправления:

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: New server to improve performance on our large and busy DB - advice?
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: New server to improve performance on our large and busy DB - advice?