| 18 Dec 2023 |
 raitobezarius | public.jobsetevalmembers | 186 GB
| 12:53:09 |
 K900 | Whee | 12:53:29 |
| raitobezarius | * just realized that the M2M between builds and evals | 12:53:33 |
| K900 | Can we at least make a backup of the database and truncate some history | 12:53:39 |
| raitobezarius | it's a stupid (left_id, right_id, bool) table of course | 12:53:43 |
| K900 | I don't know if I want to know the answer to this question | 12:54:03 |
| K900 | But what is the bool for | 12:54:05 |
| raitobezarius | In reply to @k900:0upti.me
Can we at least make a backup of the database and truncate some history you'd break our 2010 urls for performance ??? | 12:54:06 |
| raitobezarius | In reply to @k900:0upti.me
But what is the bool for isnew | 12:54:10 |
| raitobezarius | hydra-nixos-org=# \d jobsetevalmembers
Table "public.jobsetevalmembers"
Column | Type | Collation | Nullable | Default
--------+---------+-----------+----------+---------
eval | integer | | not null |
build | integer | | not null |
isnew | integer | | not null |
| 12:54:17 |
| K900 | Ah yes] | 12:54:24 |
| K900 | * Ah yes | 12:54:25 |
| K900 | A bool | 12:54:26 |
| raitobezarius | oh fuck lol | 12:55:39 |
| raitobezarius | I didn't even realize that | 12:55:42 |
| raitobezarius | it's wasting so many fucking bytes by using an integer | 12:55:51 |
| raitobezarius | let me get the count so I can get a feeling | 12:56:21 |
| raitobezarius | hydra-nixos-org=# select count(*) from jobsetevalmembers;
count
------------
2417504605
(1 row)
| 12:56:39 |
 Sandro | In reply to @raitobezarius:matrix.org
you'd break our 2010 urls for performance ??? Yes 👀 | 13:13:52 |
| Sandro | In reply to @raitobezarius:matrix.org
it's wasting so many fucking bytes by using an integer So we could save maybe a third of database size by using the correct type there? | 13:16:57 |
| raitobezarius | not 1/3 | 13:17:10 |
| Sandro | but still a lot? 😅 | 13:46:34 |
| K900 | Honestly Postgres doesn't really care about on disk size too much | 15:22:55 |
| K900 | Especially when there's likely an index on those anyway | 15:23:05 |
 jackdk | In reply to @tomberek:matrix.org
When hydra is doing it, there are a few options.... either a store variable with ?secret-key set, or via a RunCommand hook. Thanks Tom, I've opened https://github.com/NixOS/hydra/pull/1328 to capture this knowledge in the manual. | 21:59:50 |
| 20 Dec 2023 |
|  bb_wtt.jpeg joined the room. | 11:58:51 |
| 21 Dec 2023 |
|  eyduh (she/they) joined the room. | 02:18:55 |
| 22 Dec 2023 |
|  medliviz joined the room. | 12:31:41 |
| 23 Dec 2023 |
|  @arcayr:rascals.net joined the room. | 16:04:53 |
| raitobezarius changed their display name from raitobezarius to raitobezarius (DECT 2128). | 22:22:47 |
bb_wtt.jpeg joined the room.