Re: SELECT speed with LIKE

From: "Robert W(dot) Berger" <rwb(at)vtiscan(dot)com>
To: Jim Richards <grumpy(at)cyber4(dot)org>, pgsql-general(at)postgresql(dot)org
Subject: Re: SELECT speed with LIKE
Date: 2000-04-09 05:32:33
Message-ID: 27028.3164232753@porter.vtiscan.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

The locale problem only affects the speed once it decides to use an index;
it does not affect whether it chooses an index or sequential scan.

Try doing a VACUUM ANALYZE; that often makes it start using index scans.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Frank P. Miles 2000-04-09 12:35:22 Re: granting permission to groups?
Previous Message Peter Eisentraut 2000-04-09 01:32:14 Re: Changes doc for 7.0 beta 4?