Timeline for PostgreSQL - Working with array of thousands of elements
Current License: CC BY-SA 3.0
18 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) | |
| Jun 24, 2019 at 5:01 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Feb 24, 2019 at 5:00 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Apr 13, 2018 at 12:50 | comment | added | Daniel Vérité | external sort Disk: 29176kB => increase your work_mem such that these relatively small sorts happen in memory not on disk. | |
| Apr 6, 2018 at 19:25 | history | edited | Jukurrpa | CC BY-SA 3.0 | added 2487 characters in body |
| Apr 4, 2018 at 18:41 | history | edited | Evan Carroll | edited tags | |
| Apr 4, 2018 at 18:36 | answer | added | Evan Carroll | timeline score: 2 | |
| Apr 4, 2018 at 18:27 | history | edited | Evan Carroll | edited tags | |
| Apr 4, 2018 at 18:11 | comment | added | Jukurrpa | Sure, added the explain analyze to the question. | |
| Apr 4, 2018 at 18:10 | history | edited | Jukurrpa | CC BY-SA 3.0 | Added explain analyze, updated original query |
| Apr 4, 2018 at 8:53 | comment | added | Colin 't Hart | Can you post the execution plan you're getting? | |
| Apr 2, 2018 at 19:22 | comment | added | Jukurrpa | About 12 million rows in mytable, with about 500k different item_id. There is no real natural unique key for this table, it's data that's generated automatically for repeating events. I guess the item_id + start_date + name (field not shown here) could constitute some kind of key. | |
| Mar 31, 2018 at 3:03 | comment | added | Nick | Also, shouldn't you have uniqueness constraint (probably not-yet-defined unique index) in on item_id in mytable? ... Edited: oh, I see "PARTITION BY item_id", so this question transforms to "What is the natural, real key for your data? What should form unique index there?" | |
| Mar 31, 2018 at 3:00 | comment | added | Nick | How many rows in "mytable"? How many different "item_id" values there? | |
| Mar 31, 2018 at 2:55 | history | tweeted | twitter.com/StackDBAs/status/979915104941674496 | ||
| Mar 30, 2018 at 22:27 | history | edited | Jukurrpa | CC BY-SA 3.0 | edited title |
| Mar 30, 2018 at 22:13 | review | First posts | |||
| Mar 30, 2018 at 22:21 | |||||
| Mar 30, 2018 at 22:10 | history | asked | Jukurrpa | CC BY-SA 3.0 |