Timeline for How to make this query use my multicolumn index?
Current License: CC BY-SA 3.0
15 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 7, 2020 at 22:25 | history | edited | CommunityBot |
added [postgresql-performance] to 571 questions - Shog9 (Id=1924)
|
|
| Oct 2, 2015 at 16:36 | history | edited | Erwin Brandstetter | CC BY-SA 3.0 |
sharpen title
|
| Oct 1, 2015 at 12:53 | history | tweeted | twitter.com/#!/StackDBAs/status/649567935841873920 | ||
| S Oct 1, 2015 at 12:46 | history | suggested | Christopher Schultz | CC BY-SA 3.0 |
Fixed grammar in title
|
| Oct 1, 2015 at 12:35 | review | Suggested edits | |||
| S Oct 1, 2015 at 12:46 | |||||
| Oct 1, 2015 at 12:29 | history | edited | Erwin Brandstetter | CC BY-SA 3.0 |
tags, minor edits
|
| Oct 1, 2015 at 12:04 | vote | accept | Christian Schmitt | ||
| Oct 1, 2015 at 12:04 | vote | accept | Christian Schmitt | ||
| Oct 1, 2015 at 12:04 | |||||
| Oct 1, 2015 at 12:04 | vote | accept | Christian Schmitt | ||
| Oct 1, 2015 at 12:04 | |||||
| Oct 1, 2015 at 11:55 | answer | added | András Váczi | timeline score: 3 | |
| Oct 1, 2015 at 11:50 | answer | added | Erwin Brandstetter | timeline score: 6 | |
| Oct 1, 2015 at 11:48 | comment | added | Christian Schmitt | eh yes I alread did that, and had the same behavior.. | |
| Oct 1, 2015 at 11:46 | comment | added | Lennart - Slava Ukraini |
I'm no expert on postgresql, but I believe that the function ( lower ) in your predicate will make uit difficult to use the index. Have you tried to create an index with an expression? I.e. CREATE INDEX ... ON ...(lower(name), ...)
|
|
| Oct 1, 2015 at 11:35 | history | edited | András Váczi | CC BY-SA 3.0 |
added 202 characters in body
|
| Oct 1, 2015 at 11:12 | history | asked | Christian Schmitt | CC BY-SA 3.0 |