News for hackers. Stuff that matters.

Vadim_samokhin

Re: on Tuesday March 10, 2026 @04:31AM (#47320504)
Just in case, there is a btree_gin extension which can be used in queries combining gin-indexable column and btree-indexable column. It doesn’t solve top-K ordering problem though.
Re:Smurf: Beyond the Test Pyramid on Sunday October 20, 2024 @12:04AM (#41892775)
I think test pyramid is a great idea, in theory. In practice, having lots of unit tests with mocked dependencies doesn’t make me sure that everything works as it should. Thus, I use real database in my unit tests. There, I test serialization errors, authentication problems, network issues, etc. All the real problems which can occur in real life. Leaving these scenarios for integration tests layer will turn a test pyramid to a test diamond.

And what was the rationale behind mocking a database in the first place, speed? Disable synchronous wal writes, or run your postgres instance in ram. Your test suite execution speed will skyrocket.

Whoa, the first step towards a garbage collector? :)
Re:The Plan-Execute Pattern on Wednesday June 26, 2024 @03:43PM (#40803812)
I think postgres really excelled at this pattern. As well as other databases implementing a query planner.
Re:How to Get the Most Out of Postgres Memory Settings on Wednesday June 12, 2024 @02:38PM (#40661388)
> And yes, absolutely _never_ make it your primary key.

If I dont have lots of range queries, why not then? Only because of bloating (I think fragmentation is a more precise term here)?

Re:Stopping at 90% on Wednesday August 02, 2023 @02:45PM (#36975171)
I think scruple meant not just putting a github nickname, but specific links to repos. That’s what I do - but people still don’t give a shit.