X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id E551953E65 for ; Mon, 9 May 2005 16:48:19 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 79367-07 for ; Mon, 9 May 2005 19:48:14 +0000 (GMT) Received: from koolancexeon.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by svr1.postgresql.org (Postfix) with ESMTP id 2F80753E45 for ; Mon, 9 May 2005 16:48:13 -0300 (ADT) Received: mail.g2switchworks.com 10.10.1.8 from 10.10.1.37 10.10.1.37 via HTTP with MS-WebStorage 6.5.6944 Received: from state.g2switchworks.com by mail.g2switchworks.com; 09 May 2005 14:48:12 -0500 Subject: Re: conversion security update may have slowed our system? From: Scott Marlowe To: Tom Lane Cc: Simon Riggs , =?iso-8859-2?Q?Sz=FBcs_G=E1bor?= , PGA In-Reply-To: <420.1115665807@sss.pgh.pa.us> References: <427F5E01.1040404@gmail.com> <25256.1115646869@sss.pgh.pa.us> <1115664908.3830.33.camel@localhost.localdomain> <420.1115665807@sss.pgh.pa.us> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1115668092.3868.145.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Mon, 09 May 2005 14:48:12 -0500 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200505/100 X-Sequence-Number: 17529 On Mon, 2005-05-09 at 14:10, Tom Lane wrote: > Simon Riggs 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.