Re: conversion security update may have slowed our system?

From: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Simon Riggs <simon(at)2ndquadrant(dot)com>, Szűcs Gábor <surrano(at)gmail(dot)com>, PGA <pgsql-admin(at)postgresql(dot)org>
Subject: Re: conversion security update may have slowed our system?
Date: 2005-05-09 19:48:12
Message-ID: 1115668092.3868.145.camel@state.g2switchworks.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Mon, 2005-05-09 at 14:10, Tom Lane wrote:
> Simon Riggs <simon(at)2ndquadrant(dot)com> writes:
> > Your original release was 7.3.3 and you have just moved to 7.3.9.
>
> Did he move to 7.3.9? I got the impression he'd only applied the
> recommended catalog change to his existing installation. But if he
> did, then you're right, it's more than likely got something to do
> with some other change in the 7.3 series.

Most of the time I've seen this happen, the change has made the query
planner do something differently, and explain analyze has shown the
problem rather quickly.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Simon Riggs 2005-05-09 21:38:35 Re: Concurrency
Previous Message Thomas F.O'Connell 2005-05-09 19:30:34 Re: IMPORTANT: two new PostgreSQL security problems found