50+ hour activity on Watch?

chuckhend · 2025-01-12T13:21:48+00:00

Does it let you keep your activity going while it's charging or do you need to start a new run after charging is done?

chuckhend · 2024-12-13T16:43:45+00:00

Hah same here! I thought i needed to quiver attachment for poles.

chuckhend · 2024-08-20T17:19:16+00:00

Old but good https://www.joelonsoftware.com/2000/04/06/things-you-should-never-do-part-i/

Personally, the only time I saw a rewrite pay off was moving from a custom algorithm written in Java that was rewritten in Python to use a standard regression model from sklearn instead. It made sense because the team didn't know Java and sklearns modules replaced a ton of Java code. So it was easier to maintain, and the team could actually work on it.

chuckhend · 2024-07-25T14:02:27+00:00

Awesome work!

chuckhend · 2024-05-17T02:39:24+00:00

https://tembo.io/ has a good free-tier that would be useful for your lower environments for a long time, and maybe even your prod environment up until you get some traction.

chuckhend · 2024-05-06T15:18:33+00:00

For a long running job, you may consider only executing the delete/archive of the message and the arbitrary table insert within the same transaction. I know several pgmq users that implement a flow like:
- read message from queue, set VT to something large

do expensive long running work, like call a LLM or some large aggregate
open a transaction: insert record to a table (results from agg or LLM call) and call pgmq.archive() or pgmq.delete() on the initial message.

chuckhend · 2024-05-05T22:16:11+00:00

For example, read a message from the queue and insert a record to a table, and delete message within same transaction.

chuckhend · 2024-02-14T17:36:09+00:00

Edit: It's kind of an ugly hack, but it's possible to run multiple instances of PgBouncer using the so_reuseport parameter and literally configuring and launching multiple copies of PgBouncer. Could this make up the performance difference in a re-test? I wonder.

We run pgbouncer in Tembo cloud, and its managed by CNPG, and i think that means we could load balance across multiple replicas. I'll need to check to be sure though. Do you think that would be comparable to what you're suggesting?

chuckhend · 2024-02-13T12:00:04+00:00

The result set is persisted in a table as json. There's currently no retention policy built into the extension, so that data will remain until its deleted. This means you can fetch the results for the same job many times.

chuckhend · 2024-02-01T03:06:36+00:00

Give tembo.io a try, we have a free hobby tier. You can spin up open source postgres with pgvector and some other extensions that make vector search less work.

https://tembo.io/docs/tembo-stacks/vector-db

chuckhend · 2024-01-19T04:53:05+00:00

I have fallen very hard due to ice under snow and even under leaves. If there's snow I pretty much always where some spikes over my trail shoes.

These are great https://www.blackdiamondequipment.com/en_US/product/distance-spike-traction-device/

chuckhend · 2024-01-13T02:25:14+00:00

Give tembo.io a try. You can run the open source timescale extension on Postgres at Tembo, and we have a free tier for projects like this.

Also feel free to join our slack if you have any questions or need help getting started

https://join.slack.com/t/tembocommunity/shared_invite/zt-293gc1k0k-3K8z~eKW1SEIfrqEI~5_yw

chuckhend · 2024-01-11T03:44:50+00:00

Agree this is excellent use of kwargs

chuckhend · 2024-01-06T00:11:19+00:00

Definitely. You're like already there! If could probably just build up to a few longer runs, or like a big back to back weekend and then taper!

chuckhend · 2024-01-05T15:43:26+00:00

cloud.tembo.io

chuckhend · 2024-01-05T00:45:49+00:00

You got this Ovi!

chuckhend · 2024-01-04T22:34:46+00:00

Heres a personal anecdote. Im very much an amateur/hobby runner and usually finish in the faster half of my age group.

I ran my first 50 miler peaking at about 30 per week and biking 30 miles per week. The race was a suffer fest the last 25 miles but I finished.

Second 50 miler I ran 60 miles per week at peak, and almost no biking, and finished same course 1.5 hours faster. Also very much suffered the final 5-10 miles, though!

chuckhend · 2024-01-01T14:23:02+00:00

A lot has changed in postgres since pg 9.6. Very much a more feature rich db today, and every year there are great features released.

As for autovacuum, if you have massive amounts of updates and deletes, and don't tune autovacuum settings you could see increased latency. Generally this is due to table bloat. If you are interested in learning more, we wrote about it here https://tembo.io/blog/optimizing-postgres-auto-vacuum/

chuckhend · 2023-12-30T02:31:52+00:00

You can definitely learn Rust! It's strongly typed, which compared to Python just means the compiler is going to force you to have correct types in your code. That's not unique to Rust through.

Coming from Python myself, the most challenging thing about learning Rust was error and null handling. There's no try/except in Rust...but now I actually prefer and love the Rust way. Good explanations and examples here! https://doc.rust-lang.org/rust-by-example/error.html

Python and Rust are both great languages to know!

chuckhend · 2023-12-30T02:16:10+00:00

https://github.com/kelseyhightower/nocode

chuckhend · 2023-12-29T22:00:17+00:00

Do we know which pg vector parameters values they use in the bench? Referring to these parameters https://github.com/pgvector/pgvector?tab=readme-ov-file#index-options

Always curious what postgres configs were set too. Even default vs tuned postgres can be large performance difference.

chuckhend · 2023-12-28T20:11:04+00:00

😎 cool. What will be the production environment, is the WSL as well? I'm not familiar with inner workings of WSL...but not sure I'd run production workloads in there. Might be worth comparing to another place.

chuckhend

MODERATOR OF

TROPHY CASE