"Guillaume Smet" <guillaume.smet@xxxxxxxxx> writes: > On 11/7/07, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: >> Hmmm ... what locale are you working in? I notice that the range >> estimator for this pattern would be "ancestors >= '1062/' AND >> ancestors < '10620'", which will do the right thing in C locale >> but maybe not so much elsewhere. > Sorry for not having mentioned it before. Locale is UTF-8. I wanted the locale (lc_collate), not the encoding. > I suppose my best bet is to remove the pg_statistic line and to set > the statistics to 0 for this column so that the stats are never > generated again for this column? That would optimize this particular query and probably pessimize a lot of others. I have another LIKE-estimation bug to go look at today too; let me see if this one is fixable or not. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
