Timeline for Implementing fast and deterministic sort order in PostgreSQL with pg_trgm
Current License: CC BY-SA 4.0
12 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 16, 2021 at 9:14 | vote | accept | vkopio | ||
| Nov 13, 2021 at 21:43 | answer | added | jjanes | timeline score: 2 | |
| Nov 12, 2021 at 12:02 | history | edited | vkopio | CC BY-SA 4.0 |
Fix formatting
|
| Nov 11, 2021 at 14:41 | comment | added | vkopio |
Some EXPLAIN ANALYZEs added. As I feared, there probably is no plain Postgres solution for this problem.
|
|
| Nov 11, 2021 at 14:39 | history | edited | vkopio | CC BY-SA 4.0 |
Added explain analyze as requested
|
| Nov 11, 2021 at 2:43 | comment | added | Laurenz Albe | I don't think that is possible. | |
| Nov 10, 2021 at 18:32 | comment | added | jjanes |
Please show the explain (analyze) for the various queries you show.
|
|
| Nov 10, 2021 at 18:18 | comment | added | jjanes | I generally find gist_trgm_ops scales quite poorly to large datasets and large texts. Can you give us some idea of the number of rows, and the size, nature, and complexity of searchable_column? | |
| Nov 10, 2021 at 14:40 | history | edited | vkopio | CC BY-SA 4.0 |
Fix wording
|
| Nov 10, 2021 at 14:31 | history | edited | vkopio | CC BY-SA 4.0 |
More typo fixes and improved formatting
|
| S Nov 10, 2021 at 14:22 | review | First questions | |||
| Nov 10, 2021 at 15:33 | |||||
| S Nov 10, 2021 at 14:22 | history | asked | vkopio | CC BY-SA 4.0 |