Re: GIN index not used if created in the same transaction as query

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

Subject: Re: GIN index not used if created in the same transaction as query
From: Adam Brusselback <adambrusselback@xxxxxxxxx>
Date: Fri, 19 May 2017 11:49:32 -0400
Arc-authentication-results: i=1; mx.google.com; dkim=pass header.i=@gmail.com; spf=pass (google.com: best guess record for domain of pgsql-performance-owner+m55031=spinic=gmail.com@xxxxxxxxxxxxxx designates 2a02:16a8:dc51::56 as permitted sender) smtp.mailfrom=pgsql-performance-owner+M55031=spinic=gmail.com@xxxxxxxxxxxxxx; dmarc=pass (p=NONE sp=NONE dis=NONE) header.from=gmail.com
Arc-message-signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20160816; h=sender:precedence:list-unsubscribe:list-subscribe:list-post :list-owner:list-id:list-help:list-archive:cc:to:subject:message-id :date:from:references:in-reply-to:mime-version:dkim-signature :arc-authentication-results; bh=M7T8DbKexy1y3H6zV4+lEYSKrXPzBIspfPtxDYnWrmo=; b=J3HWNYENsMSZUdQKvbVKO2uEY823ywDy11FIrVMY69sLUoeRaO6QViv5gNhFUZ4bjb LDhuehu5dPcKZqJ6njl2OR//pZhNjZnT9iGoh5TRgUWu+uHGj7mLWpVLzTDToyuYYn3r JqemfYEn1hwFbo+bBp+wfGg/nieLrM7+lM+IOW4RzPfXx+Oto342wEPgJDPiibp8B4Mk F7rv71fWh4/4qBA7ZvQUWMtNCOFT9PVZvJCd4ZsAFQ/mQKXtx4BtgLuX3TUKsLRicqta L0wdedpdjbmZPcYAhmMrq7nYyrYG7SMvjq5zzjWZfEnloaH2WyPVPUTfAEHOky7CiKtD 0dDw==
Arc-seal: i=1; a=rsa-sha256; t=1495209014; cv=none; d=google.com; s=arc-20160816; b=xLDpuV/xiv/J48msJVCqfxUeQ4BE1J8opo7XR8PYJ6EY+rr3ciV2SjbU6MuLjXoL4F N3rt/jOHx1RaH0ycpaIQb7qEfR1+SkDEYax2jYvGETDwkujpFH9M57BroN+kLU723RR0 g+ckOL8ITM4aZT0L5EW6C7la4luyAaeHxWa212YSFUyPb3emehf5U3FbBtnVrEHHzo/9 6NNcfFzQEhxo2pBUsTf5EJyTYqH9EI+1lqqFr97ZFgOAc7lqGMEUAujNkeSofBzpoHfO BX7yhHcdWbG29n4gB9Y1J4Uhyxc8T1ajbMa+6fHHXR2XuYlpNNV8anrU9vkgboZuwvei 5Utg==
Cc: pgsql-performance@xxxxxxxxxxxxxx
In-reply-to: <31274.1495208001@sss.pgh.pa.us>
References: <CAMjNa7c_=5pZL8T-kBhiRb0=an=DbpGg5jsYZ9guDs8i75jwcg@mail.gmail.com> <31274.1495208001@sss.pgh.pa.us>

Does the "multiple steps" part involve UPDATEs on pre-existing rows?
Do the updates change the column(s) used in the gin index?

Yes they do, however the updates happen prior to the index creation.

I just tried, and that looks like the solution. I really appreciate your help on this.

Is there any easy way I can know if an index is usable or not? Are there any catalog views or anything I could check that in?

Thanks,

-Adam

Follow-Ups:
- Re: GIN index not used if created in the same transaction as query
  - From: Tom Lane

References:
- GIN index not used if created in the same transaction as query
  - From: Adam Brusselback
- Re: GIN index not used if created in the same transaction as query
  - From: Tom Lane

Prev by Date: Re: GIN index not used if created in the same transaction as query
Next by Date: Re: GIN index not used if created in the same transaction as query
Previous by thread: Re: GIN index not used if created in the same transaction as query
Next by thread: Re: GIN index not used if created in the same transaction as query
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]