Search Postgresql Archives

Re: To create or not to create that index

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

Subject: Re: To create or not to create that index
From: "David G. Johnston" <david.g.johnston@xxxxxxxxx>
Date: Thu, 17 Aug 2023 20:45:27 -0700
Cc: pgsql-general <pgsql-general@xxxxxxxxxxxxxx>
In-reply-to: <CAP50yQ8vkh_msm6ZKeeVvvquNOwM2M5L4fB8KQ9kKBNrWyswXg@mail.gmail.com>
References: <CAP50yQ-nzmVB7amZkTxN3ute4NKyoTKH-3eEnVEJPTNaFSLyOQ@mail.gmail.com> <CAKFQuwbtRgufOWG1jUuG+DJqiVs1=3g6e0Kk2shZ8xqzQaaY4A@mail.gmail.com> <CAP50yQ8vkh_msm6ZKeeVvvquNOwM2M5L4fB8KQ9kKBNrWyswXg@mail.gmail.com>

On Thu, Aug 17, 2023 at 8:43 PM Stefan Knecht <knecht.stefan@xxxxxxxxx> wrote:

But that "invalid" index is being used by queries....

Please don't top-post.

If it is used by queries it isn't invalid and thus its existence shouldn't be surprising. So I'm not sure what you are saying.

David J.

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

References:
- To create or not to create that index
  - From: Stefan Knecht
- Re: To create or not to create that index
  - From: David G. Johnston
- Re: To create or not to create that index
  - From: Stefan Knecht

Prev by Date: Re: To create or not to create that index
Next by Date: Re: To create or not to create that index
Previous by thread: Re: To create or not to create that index
Next by thread: Re: To create or not to create that index
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]

Powered by Linux