Hacker Newsnew | past | comments | ask | show | jobs | submit | cocoflunchy's commentslogin

Hi, any idea of the timing to launch in europe-west1 on GCP? Also does branching work on Postgres?


Relevant interview extract from the Claude Code team: https://x.com/pashmerepat/status/1926717705660375463

> Boris from the Claude Code team explains why they ditched RAG for agentic discovery. > "It outperformed everything. By a lot"


This is very cool. They explained the solution better than I did. If I knew, I would have just linked this :)


I don't understand why pytest's collection is so slow.

On our test suite (big django app) it takes about 15s to collect tests. So much that we added a util using ripgrep to find the file and pass it as an argument to pytest when using `pytest -k <testname>`.


From my experience speeding up pytests with Django:

- Creating and migrating the test DB is slow. There is no shame in storing and committing a premigrated sqlite test DB generated upon release, it's often small in size and will save time for everyone.

- Stash your old migrations that nobody use anymore.

- Use python -X importtime and paste the result in an online viewer. Sometimes moving heavy imports to functions instead of the global scope will make individual tests slower, but collection will be faster.

- Use pytest-xdist

- Disable transactions / rollback on readonly tests. Ideally you want most of your non-inserting tests to work on the migrated/preloaded features in your sqlite DB.

We can enter into more details if you want, but the pre migrated DB + xdist alone allowed me to speedup tests on a huge project from 30m to 1m.


Agreed, the db migrations are usually the slowest part. Another way to speed this up substantially if you are using postgres and need your test database to be postgres too, is to create and maintain a template database for your tests. This database should have all migrations already run on it and be loaded with whatever general use fixtures you will need. You can then use the Django TEMPLATE setting https://docs.djangoproject.com/en/5.1/ref/settings/#template and Django will clone that database when running your tests.


Is there a way to use pytest-xdist and still keep the regular output?


In their case I think they were no specifying any test path. Which would cause pytest to search or tests in multiple directories.

Another thing that can slow down pytest collection and bootstrap is how fixture are loaded. So reducing number or scope of fixtures may help too.


I've done some work on making pytest faster, and it's mostly a case of death by a thousand paper cuts. I wrote hammett as an experimental benchmark to compare to.


Ehhh, those pesky Python people, complaining and complaining, average Spring Boot application takes 15s to start even looking if the code compiled ;)


Lest we start to malign the JVM as a whole, my Clojure test suite, which includes functional tests running headless browsers against a full app hitting real Postgres databases, runs end to end in 20s.


The spring tests are generally quicker then the equivalent python test, so ime - the jvm is mostly to blame.

How much time actually goes by after you click "run test" (or run the equivalent cli command) until the test finished running?

Any projects using the jvm I've ever worked on (none of which were clojure, admittedly) have always taken at least 10-15s until the pre-phases were finished and the actual test setup began


If I completely clear all cached packages maybe, but I never do that locally or in CI/CD, and that's true of Python too (but no doubting UV is faster than Maven). Clojure/JVM startup time is less than half a second, obviously that's still infinitely more than Python or a systems language but tolerable to me. First test runs after about 2s? And obviously day to day these things run instantly because they're already loaded in a REPL/IPython. Maybe unfair to compare an interpreted language to a compiled one: building an uberjar would add 10 seconds but I'd never do that during development, which is part of the selling point I guess. Either way, I don't think the JVM startup time is really a massive issue in 2025, and I feel like whatever ecosystem you're in, you can always attack these slow test suites and improve your quality of life.


It spins up a postgres container in that 20s?


Not a container but yes, it launches a cluster at the start of a run, and copies a blank Postgres template before every relevant test.




Not exactly this but https://search.marginalia.nu/ will probably return sites that match these criteria


Dashdoc | On-site (Paris or Nantes, France, EU) | Full-time | Equity | Roles: Product manager, Developers

We hired someone coming from HN last month!

We're building a next generation software platform for the freight trucking industry which is in great need of innovation! Lots of interesting challenges, great team!

We're hiring mostly intermediate to senior developers and one product manager to launch in the US and Spain and continue our expansion in Belgium

PM: https://dashdoc.welcomekit.co/companies/dashdoc/jobs/interna...

Backend: https://dashdoc.welcomekit.co/companies/dashdoc/jobs/senior-... Frontend: https://dashdoc.welcomekit.co/companies/dashdoc/jobs/senior-...


What I would really love is a dead simple way to: 1) connect to my transactional Postgres db 2) define my materialized views 3) have these views update in realtime 4) query these views with a fast engine

And ideally have the whole thing open source and be able to run it in CI

We tried peerdb + clickhouse but Clickhouse materialized views are not refreshed when joining tables.

Right now we’re back to standard materialized views inside Postgres refreshed once a day but the full refreshes are pretty slow… the operational side is great though, a single db to manage.


You can do this with Materialize or Feldera. The keyword to look for is “incremental view maintenance”


that's been supported in striim since 2016

https://dl.acm.org/doi/10.1145/3129292.3129294


we have the exact same problem. We tried Clickhouse but their materialized view limitations stopped us.


Yeah you definitely need something like Feldera: https://github.com/feldera/feldera


What country are you from? In France it’s always at the end for example


In Italy it's at the end, hence my interpretation


In the Netherlands it is a prefix, at the beginning.

https://nl.m.wikipedia.org/wiki/Euroteken


Same in Germany. Definitely at the end here.


Probably Netflix?


Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: