
Why did Postgres get 100x slower on the 6th run?
This one took me a while to figure out. After a load test on staging (10,000 workspaces), one query stood out: the trending list took 155 ms a page instead of 1.3 ms, and it was using 60% of the database's time.
Here is what was happening:
The driver I use (pgx) prepares every query, and PostgreSQL plans a prepared query with its real values for the first 5 runs.
On the 6th run, it can switch to a "generic" plan, made without the values, if that plan doesn't look more expensive.
My lists have optional filters (board, status, tags...). Without the values, Postgres expected to find a single post, so it went through every post of the workspace and sorted them all.
The fix was one setting: plan_cache_mode = force_custom_plan. Every query is now planned with its real values, and it costs a fraction of a millisecond.
Have you ever been bitten by this one?
I'm Elie, the maker of Swingback.
Most feedback tools stop at the vote. Someone still has to copy the request into GitHub or Linear, remember to update the post when it ships, and tell the people who asked. That last step is where it usually breaks.
Swingback closes that loop:
• Your users post and vote on your portal, or in a widget inside your app (JavaScript, React, React Native, iOS and Android SDKs)
• Pick a request, and Swingback opens the GitHub or Linear issue
• When the issue closes, the post is marked done and everyone who voted gets an email
• Statuses and comments sync both ways, and your roadmap and changelog keep up on their own
A few more things:
• Rank requests by votes, or by what the customers asking are worth
• Posts are translated automatically: users write in their language, you read in yours
• AI catches duplicate requests
• An MCP server, so Claude, ChatGPT or Codex can read and triage your feedback
• Coming from Canny, UserJot or Nolt? You can import using their API, or from a CSV
Pricing is simple: a free plan, and Pro at $20 a month, flat, however many users vote.
For the Product Hunt community: the code SWB-2PTP-AWGE gives a new workspace a month of Pro free, no card needed.
I'd love to hear what you think, and what you'd want it to do next. Happy to answer anything below!
Also feel free to come say hi on X, I share my journey there and some insight into my build process ;)