Timeline for Postgresql: Partition table by hour
Current License: CC BY-SA 3.0
15 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 20 at 9:03 | 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 12 at 17: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. | |
| Dec 14, 2023 at 12: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. | |
| Aug 5, 2023 at 15: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. | |
| Apr 5, 2023 at 7: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. | |
| Dec 1, 2022 at 6:05 | 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. | |
| Jul 27, 2022 at 18:09 | 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. | |
| Mar 27, 2022 at 12:04 | 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. | |
| Nov 21, 2021 at 6:02 | 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. | |
| Jul 17, 2021 at 21:07 | 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. | |
| Mar 15, 2021 at 9:59 | comment | added | Mike Sherrill 'Cat Recall' | In your partition tables, would you not rather index the expression 'extract(hour from "timestamp")' rather than just indexing "timestamp"? Also consider whether upgrading PostgreSQL is called for. Version 9.3 isn't supported, and I think partitioning got simpler starting with version 10. | |
| Mar 15, 2021 at 9:07 | 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 11, 2021 at 12:29 | answer | added | user953 | timeline score: 0 | |
| Feb 23, 2015 at 14:03 | history | edited | CurtisHx | CC BY-SA 3.0 |
Added a bit more info.
|
| Feb 20, 2015 at 16:43 | history | asked | CurtisHx | CC BY-SA 3.0 |