| 23 Aug 2023 |
 @linus:schreibt.jetzt | that is, adjust the chunking so that you get fewer chunks, but also less effective deduplication | 11:19:41 |
 raitobezarius | postgres defaults are extremely conservative | 11:23:32 |
| raitobezarius | tuning postgres is probably the easiest | 11:23:38 |
| @linus:schreibt.jetzt | I'm trying that out now | 11:30:32 |
| @linus:schreibt.jetzt | using https://pgtune.leopard.in.ua/ and the web application profile | 11:30:44 |
| @linus:schreibt.jetzt | though maybe desktop is more suitable given that it's not a dedicated machine | 11:31:39 |
| @linus:schreibt.jetzt | well, I'll find out :) | 11:31:47 |
 Julien | I’ll use my Raito script to tune postgres | 11:50:43 |
| raitobezarius | krkrkrkrkr | 11:54:46 |
| @linus:schreibt.jetzt | hm, it seems to result in more successes, but doesn't entirely eliminate the failures | 12:03:42 |
| raitobezarius | what is the nature of pgsql connections that attic does? | 12:04:52 |
| raitobezarius | read or write? | 12:04:55 |
| @linus:schreibt.jetzt | I could also imagine that atticd doesn't reuse connections well enough | 12:05:01 |
| raitobezarius | in some cases, a pooler could help | 12:05:04 |
| raitobezarius | yeah | 12:05:07 |
| @linus:schreibt.jetzt | it does pool them | 12:05:08 |
| @linus:schreibt.jetzt | Aug 23 13:58:54 garage-muc atticd[286]: 2023-08-23T11:58:54.590061Z ERROR tower_http::trace::on_failure: response failed classification=Status code: 500 Internal Server Error latency=30003 ms
Aug 23 14:02:44 garage-muc atticd[286]: 2023-08-23T12:02:44.976132Z ERROR attic_server::error: Database error: Failed to acquire connection from pool
| 12:05:45 |
| raitobezarius | how many connections do you allow now? | 12:06:02 |
| @linus:schreibt.jetzt | I have no idea :D | 12:06:08 |
| @linus:schreibt.jetzt | maybe I should just dig into it rather than putting every intermediate thought in here :p | 12:06:39 |
| raitobezarius | max_connections is the right knob | 12:06:51 |
| @linus:schreibt.jetzt | I don't think this is on the postgres side, it's on the attic side | 12:07:15 |
| raitobezarius | Ah right I agree | 12:07:27 |
| raitobezarius | https://github.com/NixOS/nixos-org-configurations/tree/master/metrics/fastly | 13:19:45 |
| raitobezarius | We kinda have weak popcount | 13:20:49 |
| 24 Aug 2023 |
 Mic92 | I actually wonder if attic is not massively increasing the s3 costs over just downloading nars because it splits up nars into smaller files that can be deduplicated. You pay also per request and not just for the bandwidth. | 06:53:29 |
| Mic92 | I also noticed when using local storage it will put all objects in one directory. This might scale badly for large number of files. It's better to create subdirectories based on the filename prefix. | 06:55:28 |
 @andreas.schraegle:helsinki-systems.de | In reply to @joerg:thalheim.io
I actually wonder if attic is not massively increasing the s3 costs over just downloading nars because it splits up nars into smaller files that can be deduplicated. You pay also per request and not just for the bandwidth. that depends on your s3 provider | 08:10:33 |
| raitobezarius | In reply to @joerg:thalheim.io
I actually wonder if attic is not massively increasing the s3 costs over just downloading nars because it splits up nars into smaller files that can be deduplicated. You pay also per request and not just for the bandwidth. we can run simulations against AWS S3 | 08:57:53 |
| raitobezarius | I am running attic seriously yet so I don't know how easy this is | 08:58:03 |
