| From: | Andrew Sullivan <andrew(at)libertyrms(dot)info> |
|---|---|
| To: | Postgresql performance <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: v7.2.3 versus v7.3 -> huge performance penalty for JOIN with UNION |
| Date: | 2002-12-02 16:00:12 |
| Message-ID: | 20021202110012.G12906@mail.libertyrms.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-12-02 16:13:44 | Re: v7.2.3 versus v7.3 -> huge performance penalty for JOIN with UNION |
| Previous Message | ir. F.T.M. van Vugt bc. | 2002-12-02 15:45:55 | v7.2.3 versus v7.3 -> huge performance penalty for JOIN with UNION |