Re: conversion security update may have slowed our system? - Mailing list pgsql-admin

From Simon Riggs
Subject Re: conversion security update may have slowed our system?
Date
Msg-id 1115664908.3830.33.camel@localhost.localdomain
Whole thread Raw
In response to Re: conversion security update may have slowed our system?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: conversion security update may have slowed our system?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
On Mon, 2005-05-09 at 09:54 -0400, Tom Lane wrote:
> =?ISO-8859-2?Q?Sz=FBcs_G=E1bor?= <surrano@gmail.com> writes:
> > According to user reports, the production server slowed down noticeably on
> > Friday and is almost unbearably slow today (Monday). My humble question is,
> > could you think of any way this patch could affect overall speed, or is it
> > just a fatal coincidence?
>
> I can't see that there could be any connection.  You need to be looking
> for other explanations, not an "undo".

Szucs,

Your original release was 7.3.3 and you have just moved to 7.3.9. Thats
a large jump to have made, so many things are likely to have changed. It
doesn't seem likely that it was the 7.3.8 -> 7.3.9 jump, but many others
things have changed. You need to establish some means of measuring your
system's performance other than user reports, so you can verify problems
objectively.

Tom,

It seems reasonable to publish some backout information with every patch
to say whether or not it is possible to downgrade should a problem be
found. That could also be accompanied with a "has not been tested"
caveat if need be. Maybe Szucs hasn't found one this time, but there is
a possibility and many people don't have a long time to decide with a
production system looking unstable.

Best Regards, Simon Riggs


pgsql-admin by date:

Previous
From: Kris Kiger
Date:
Subject: Concurrency
Next
From: Simon Riggs
Date:
Subject: Re: Concurrency