rays/ipx
1
0
Fork 0
Code Issues 1 Pull Requests Actions Packages Projects Releases Wiki Activity

Run the load tests on Postgres, as production runs #139

New Issue
Closed
opened 2026-10-05 10:38:09 -07:00 by rays · 1 comment
rays commented 2026-10-05 10:38:09 -07:00
Owner
Copy Link

The load tests (#133) run their scratch daemon on SQLite, so their numbers carry SQLite's one connection (#136) and its locking, not what production sees on Postgres 18. The harness wipes its SQLite files before each run; on Postgres it would need a database of its own, emptied first (a throwaway container, or DROP SCHEMA public CASCADE), and a way to reach it from wherever the tests run.

The load tests (#133) run their scratch daemon on SQLite, so their numbers carry SQLite's one connection (#136) and its locking, not what production sees on Postgres 18. The harness wipes its SQLite files before each run; on Postgres it would need a database of its own, emptied first (a throwaway container, or DROP SCHEMA public CASCADE), and a way to reach it from wherever the tests run.
rays added the enhancement label 2026-10-05 10:38:09 -07:00
rays commented 2026-10-05 11:33:00 -07:00
Author
Owner
Copy Link

Done in bbdcbe2: node tests/load/run.js --postgres runs the daemon in IPX_TEST_DATABASE_URL (ipodderx_test on production's server, as ipodderx, in /src/.envrc from ipx.env), schema ipx_load made afresh each run, refusing any database not named *_test, with ANALYZE after seeding. Budgets are per database. All four pass on both. Running it found #140.

Done in bbdcbe2: node tests/load/run.js --postgres runs the daemon in IPX_TEST_DATABASE_URL (ipodderx_test on production's server, as ipodderx, in /src/.envrc from ipx.env), schema ipx_load made afresh each run, refusing any database not named *_test, with ANALYZE after seeding. Budgets are per database. All four pass on both. Running it found #140.
rays closed this issue 2026-10-05 11:33:01 -07:00
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
bug
Something is not working
 duplicate
This issue or pull request already exists
 enhancement
New feature
 help wanted
Need some help
 invalid
Something is wrong
 question
More information is needed
 wontfix
This won't be fixed
No Label enhancement
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
rays
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: rays/ipx#139
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?