Timeline for PosgtreSQL GIN + BTree ordering
Current License: CC BY-SA 3.0
18 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 7, 2020 at 22:23 | history | edited | CommunityBot |
added [query-performance] to 2412 questions - Shog9 (Id=1924)
|
|
| Nov 25, 2017 at 12:14 | vote | accept | malejpavouk | ||
| Nov 25, 2017 at 12:14 | history | edited | malejpavouk | CC BY-SA 3.0 |
added 406 characters in body
|
| Nov 23, 2017 at 7:19 | history | edited | malejpavouk | CC BY-SA 3.0 |
added 1270 characters in body
|
| Nov 22, 2017 at 22:50 | history | edited | malejpavouk | CC BY-SA 3.0 |
added 484 characters in body
|
| Nov 22, 2017 at 22:34 | history | edited | malejpavouk | CC BY-SA 3.0 |
added 11 characters in body
|
| Nov 22, 2017 at 22:26 | history | edited | malejpavouk | CC BY-SA 3.0 |
added 11 characters in body
|
| Nov 22, 2017 at 22:19 | history | edited | malejpavouk | CC BY-SA 3.0 |
added 1586 characters in body
|
| Nov 22, 2017 at 20:27 | history | edited | malejpavouk | CC BY-SA 3.0 |
added 1199 characters in body
|
| Nov 22, 2017 at 18:57 | answer | added | Evan Carroll | timeline score: 1 | |
| Nov 22, 2017 at 16:30 | comment | added | ypercubeᵀᴹ |
You need the extension: (Run create extension btree_gin; once in the database to be able to create that index)
|
|
| Nov 22, 2017 at 16:29 | comment | added | malejpavouk | I have added an edit - the problem seems to be in bitmap scan...but disabling it using SET seems quite hacky to me. | |
| Nov 22, 2017 at 16:28 | history | edited | malejpavouk | CC BY-SA 3.0 |
added 107 characters in body
|
| Nov 22, 2017 at 16:25 | comment | added | ypercubeᵀᴹ | Ah yes, there are restrictions on the types that a gin index can use. | |
| Nov 22, 2017 at 16:23 | comment | added | malejpavouk | ERROR: data type timestamp without time zone has no default operator class for access method "gin" | |
| Nov 22, 2017 at 16:22 | history | edited | malejpavouk | CC BY-SA 3.0 |
added 174 characters in body
|
| Nov 22, 2017 at 16:21 | comment | added | ypercubeᵀᴹ | What if you create a gin index with both columns? | |
| Nov 22, 2017 at 16:10 | history | asked | malejpavouk | CC BY-SA 3.0 |