Postgres Pro
Downloads
Home   >   mailing lists

Re: SELECT with LIKE clause makes full table scan - Mailing list pgsql-general

From Matthias Apitz
Subject Re: SELECT with LIKE clause makes full table scan
Date
Msg-id YfFjsGid9ZbjRxSU@c720-r368166
Whole thread Raw
In response to Re: SELECT with LIKE clause makes full table scan  (Julien Rouhaud <rjuju123@gmail.com>)
Responses Re: SELECT with LIKE clause makes full table scan
List pgsql-general
Tree view 
We changed two relevant Indexes to

CREATE INDEX d01ort ON d01buch(d01ort bpchar_pattern_ops );
CREATE INDEX d01ort2 ON d01buch(d01ort2 bpchar_pattern_ops );

and now the same queries are fast. We're looking through our code for
more such LIKE clauses on VCHAR columns.

Thanks for all the hints

    matthias
-- 
Matthias Apitz, ✉ guru@unixarea.de, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: SELECT with LIKE clause makes full table scan
Next
From: Julien Rouhaud
Date:
Subject: Re: SELECT with LIKE clause makes full table scan