Postgres Pro
Downloads
Home   >   mailing lists

Re: [PERFORM] GIN index not used if created in the same transactionas query - Mailing list pgsql-performance

From Adam Brusselback
Subject Re: [PERFORM] GIN index not used if created in the same transactionas query
Date
Msg-id CAMjNa7e-Q9DwX4TZqtuQNkitf0b0W65NsW54u7HLnMU+m2pbkw@mail.gmail.com
Whole thread Raw
In response to Re: [PERFORM] GIN index not used if created in the same transaction as query  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [PERFORM] GIN index not used if created in the same transaction as query
List pgsql-performance
Tree view
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

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: [PERFORM] GIN index not used if created in the same transaction as query
Next
From: Tom Lane
Date:
Subject: Re: [PERFORM] GIN index not used if created in the same transaction as query