Postgres Pro
Downloads
Home   >   mailing lists

Re: v7.2.3 versus v7.3 -> huge performance penalty for JOIN with UNION - Mailing list pgsql-performance

From Andrew Sullivan
Subject Re: v7.2.3 versus v7.3 -> huge performance penalty for JOIN with UNION
Date
Msg-id 20021202110012.G12906@mail.libertyrms.com
Whole thread Raw
In response to v7.2.3 versus v7.3 -> huge performance penalty for JOIN with UNION  ("ir. F.T.M. van Vugt bc." <ftm.van.vugt@foxi.nl>)
List pgsql-performance
Tree view 
On Mon, Dec 02, 2002 at 04:45:55PM +0100, ir. F.T.M. van Vugt bc. wrote:
> L.S.
>
> The query below runs 10-20 times slower under v7.3 than it did under v7.2.3:

> - v7.2.3 had no multibyte and no locale, obviously v7.3 does

Are you using the C locale?  If it was not enabled in 7.2.3, I
believe it was using C anyway; if you have some other locale, it's
now getting picked up, and that might be the source of the slower
performance (?).

A

--
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110

pgsql-performance by date:

Previous
From: "ir. F.T.M. van Vugt bc."
Date:
Subject: v7.2.3 versus v7.3 -> huge performance penalty for JOIN with UNION
Next
From: Tom Lane
Date:
Subject: Re: v7.2.3 versus v7.3 -> huge performance penalty for JOIN with UNION