Re: specific query (not all) on Pg8 MUCH slower than Pg7

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Alexander Staubo" <alex(at)purefiction(dot)net>
Cc: "Susan Russo" <russo(at)morgan(dot)harvard(dot)edu>, pgsql-performance(at)postgresql(dot)org, harvsys(at)morgan(dot)harvard(dot)edu
Subject: Re: specific query (not all) on Pg8 MUCH slower than Pg7
Date: 2007-05-08 15:05:48
Message-ID: 1406.1178636748@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Alexander Staubo" <alex(at)purefiction(dot)net> 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Susan Russo 2007-05-08 15:19:55 Re: specific query (not all) on Pg8 MUCH slower than Pg7
Previous Message Bill Moran 2007-05-08 15:04:27 Re: specific query (not all) on Pg8 MUCH slower than Pg7