Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 1BB679FBD12 for ; Tue, 8 May 2007 12:05:57 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 84671-03 for ; Tue, 8 May 2007 12:05:50 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 310809FBCC7 for ; Tue, 8 May 2007 12:05:49 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id l48F5mLc001407; Tue, 8 May 2007 11:05:48 -0400 (EDT) To: "Alexander Staubo" cc: "Susan Russo" , pgsql-performance@postgresql.org, harvsys@morgan.harvard.edu Subject: Re: specific query (not all) on Pg8 MUCH slower than Pg7 In-reply-to: <88daf38c0705080759o2e5771c3qdf1b34baa581fc53@mail.gmail.com> References: <200705081418.l48EIY8V026360@larrys.harvard.edu> <1160.1178635705@sss.pgh.pa.us> <88daf38c0705080759o2e5771c3qdf1b34baa581fc53@mail.gmail.com> Comments: In-reply-to "Alexander Staubo" message dated "Tue, 08 May 2007 16:59:30 +0200" Date: Tue, 08 May 2007 11:05:48 -0400 Message-ID: <1406.1178636748@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/123 X-Sequence-Number: 24513 "Alexander Staubo" writes: > why is there no support for changing the database locale after the fact? It'd corrupt all your indexes (or all the ones on textual columns anyway). There are some TODO entries related to this, but don't hold your breath waiting for a fix ... regards, tom lane