Re: Re: 9.2.4: Strange behavior when wildcard is on left side of search string

ERR ORR <rd0002@gmail.com> wrote:=0A=0A> the fact that in 9.2.4 it is so ba=
d that a simple query sometimes=0A> does not finish after 10+ minutes with =
incessant disk activity=0A> tends to look like a problem to me.=0A=0ATry ru=
nning a VACUUM FREEZE ANALYZE; command on the database, under=0Aa database =
superuser ID.=A0 If you upgraded with pg_dump (or some=0Aother logical popu=
lation of the data, versus a pg_upgrade run) you=0Aare probably getting bit=
ten by the initial setting of hint bits.=0A=0Ahttp://wiki.postgresql.org/wi=
ki/Hint_Bits=0A=0ASee if it is still slow after that....=0A=0A--=0AKevin Gr=
ittner=0AEnterpriseDB: http://www.enterprisedb.com=0AThe Enterprise Postgre=
SQL Company