Search Postgresql Archives

Re: SELECT with LIKE clause makes full table scan

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: SELECT with LIKE clause makes full table scan
From: Matthias Apitz <guru@xxxxxxxxxxx>
Date: Wed, 26 Jan 2022 16:07:28 +0100
Cc: Dominique Devienne <ddevienne@xxxxxxxxx>, Matthias Apitz <guru@xxxxxxxxxxx>, Josef Šimánek <josef.simanek@xxxxxxxxx>, pgsql-general <pgsql-general@xxxxxxxxxxxxxxxxxxxx>
In-reply-to: <20220126135139.uik5gbuzyxybxq4x@jrouhaud>
References: <YfEoqiHQikgT82PB@c720-r368166> <CAFp7QwrVFvMr9VOEsEQRBLhAcg9vG1AQwrg8S+mTmJ_f4Dp3sQ@mail.gmail.com> <YfEy7Y4gpoMbKlkB@pureos> <20220126121306.k6ilsxl7vy2ppmjn@jrouhaud> <CAFCRh--nsj2afcFP0iFU6_n9Hb4bSBmGu+YktkkZ8GwDXf1rYQ@mail.gmail.com> <20220126135139.uik5gbuzyxybxq4x@jrouhaud>
Reply-to: Matthias Apitz <guru@xxxxxxxxxxx>

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@xxxxxxxxxxx, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: SELECT with LIKE clause makes full table scan
  - From: Julien Rouhaud

References:
- SELECT with LIKE clause makes full table scan
  - From: Matthias Apitz
- Re: SELECT with LIKE clause makes full table scan
  - From: Josef Šimánek
- Re: SELECT with LIKE clause makes full table scan
  - From: Matthias Apitz
- Re: SELECT with LIKE clause makes full table scan
  - From: Julien Rouhaud
- Re: SELECT with LIKE clause makes full table scan
  - From: Dominique Devienne
- Re: SELECT with LIKE clause makes full table scan
  - From: Julien Rouhaud

Prev by Date: Re: SELECT with LIKE clause makes full table scan
Next by Date: Re: SELECT with LIKE clause makes full table scan
Previous by thread: Re: SELECT with LIKE clause makes full table scan
Next by thread: Re: SELECT with LIKE clause makes full table scan
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Postgresql & PHP] [Yosemite]