News for hackers. Stuff that matters.

A comment on Recursive Postgres Queries.

Re:Recursive Postgres Queries by just_hobbyst on Monday June 24, 2013 @10:23AM (#5933061)
I don't know Ruby, but does Benchmark.ms clear buffers and flush cache? If no, the second query has a large advantage, sometimes you can get similar performance improvements without changing query...
[ Parent | on HN ]
Re:Recursive Postgres Queries by tta on Monday June 24, 2013 @11:47AM (#5933657)
Good point! I've flipped the queries around.

The difference is lesser, but still fairly significant (30x).

Thanks for pointing this out.

[ Parent | on HN ]